starting #s with 0

  • Thread starter Thread starter Jackie
  • Start date Start date
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.
 
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
 
-----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.
 
Back
Top