Hi, I have a cell where numbers are entered and the number of digits varies. When I try to enter a number with a zero at the front, it drops off. For instance 0334 becomes 334.

I tried formatting cells and using custom formats but some numbers may not start with a zero and it puts a zero in front anyway. For instance 99669 will become 099669.

I want the number in the cell to display exactly as I type it.

Any suggestions?

Any help with this would be appreciated.

Thanks.