starting #s with 0

J

Jackie

Does anyone know how to enter a number in excel such as
00123 that will stay that way in the cell and not change
to 123? Please help me.
 
J

J.E. McGimpsey

If you want to use the number as a number (i.e., do math on it),
format the cell using Format/Cells/Number/Custom 00000

If instead you just want to display it (as in, say, a part number),
you can preformat the cell as Text, or prefix the number with an
apostrophe

'00123
 
S

Sandy

-----Original Message-----
Does anyone know how to enter a number in excel such as
00123 that will stay that way in the cell and not change
to 123? Please help me.
.
If you insert a ' infront of your number like
Click to expand...
this '00123, the cell should read 00123. Also, if you go
to Format - Cell and choose Text under Number description -
the cell will read 00123.
 
Top