number format

C

cheri

i have a column set up in number format, in a lot of places the first number
is 0, (zero). after i enter my info it always drops the 0. How do I correct
this? I need the 0 to be there
 
G

Gary''s Student

Two ways:

1. type a single quote (apostrophe) before the set of digits
2. if the set of digits is fixed in length, say four, then format the cell
as custom
0000
 
Top