number ZERO in a cell
 

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

number ZERO in a cell
 

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

--
sdblac
-----------------------------------------------------------------------
sdblack's Profile: http://www.excelforum.com/member.php...fo&userid=1469
View this thread: http://www.excelforum.com/showthread.php?threadid=26318

number ZERO in a cell
 

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

--
Regards,
Tom Ogilvy


wrote in message
...
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