You need to stop Excel treating your string as a number. To do this, you will
need to format the input cell as "text" - before you type anything into it.

If you're using VBA for the comparison, you'll need to make sure that any
parameter or local variable this string is going into is defined as a string,
not a number.