Cell Format

B

brenda

How can I insert a number leading off with a 0 into a cell that is formatted
as general without the 0 getting kicked?
 
G

Guest

hi,
1.format it as text(recommended)
2.custom format 00000 (or how every many characters you
need)
 
J

JE McGimpsey

If you need to use the number in subsequent calculations, choose
Format/Cells/Number/Custom, and either choose the number of digits you
want, e.g.,

0000;-0000;0000

or the number of leading zero's you want, e.g.,

"00"0;"-00"0;"000"

If the number doesn't need to be used in calculations, either preformat
the cell as Text, or prefix the entry with an apostrophe, e.g.,

'0000
 
Top