How to display zeros at the beginning of a number?

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
 
G

Gord Dibben

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
 
I

isabelle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

displaying leading zeros 3
How to count the maximum number flanked by zeros 9
Adding recognised Zeros 5
Actual solution 2
Zeros 2
Removing zeros from in front of imported data 2
leading zeros as a cell format 2
Add a decimal to each number on a list of whole numbers 2

Top