number ZERO in a cell

[Guest]

hi,

I have a cell that i want a user to enter a number into.
BUT... u know how if you enter '0123' it will change it
to '123' ... how can i KEEP the '0' at the beginning of
the number

 

[sdblack]

If you want the cell value to always be 4 digits with a leading zero
just format the cell the be four digits:

Format
Number
Custom
Type: 000

 

[Tom Ogilvy]

enter it as

'0123
(it is now text)

or format the cell as text before entry

or

if you want a number and it will always be 4 digits, format the cell with a
custom number format of 0000