Excel spreadsheet
 

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.
--
Mike D.

Hi Michael

Not clar what your question is?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Michael" wrote:

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.
--
Mike D.

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.

Michael wrote:

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.
--
Mike D.

--

Dave Peterson