How to display zeros at the beginning of a number?

  • Thread starter Thread starter Larry Allen
  • Start date Start date
L

Larry Allen

I have inventory numbers that start with zeros. How do I format cells
to display these zeros. ex../. 000456789
FYI The numbers do not have the same amount of zeros in front of them.
Thanks
 
Format as Isabelle suggests or preface with an apostrophe which won't show in
the cell.

You can pre-format the cells as Text but if you change the format you will lose
the zeros.


Gord Dibben MS Excel MVP
 
hi Gord,

no, not a text format, it is a digital format, no apostrophe!
it appears in the cell or at to print as 001234567 or 000123456
but in the formula bar is 1234567 and 123456
 
Back
Top