Excel spreadsheet

M

Michael

But what I was really looking for was a way to keep the leading zero(s) for
any length (4, 6, 3, 9, etc). Using this method, I would have to be careful
to reformat cells with numbers less than 5 digits (to avoid having extra
leading zeros at the front). Also the same for numbers of more than 5
digits, as they would still drop leading zeros.
 
D

Dave Peterson

You could use separate formats for each cell (lots of work).

Or you could format the cells as Text and just type in your values.

Or you could start each entry with an apostrophe: '001234

Both those last two options will treat your numbers as text, though.
 
Top