6 digit number with leading zeroes

Giganews Newsgroups
Subject: 6 digit number with leading zeroes
Posted by:  Vinnie (vinniena…@yahoo.com)
Date: 17 Oct 2003

I'm entering in these "Bates" numbers, such as

000001 (start);
000052; and
001952 (end)

How can I design a custom number format such that if I only enter in
the actual numerical value, i.e.,

'1' for '000001'

Excel will automatically prefix the number with the correct number of
zeroes, to always make a six digit expression?

another example given,

'1952' for '001952'

Thanks in advance,

Vinnie

Replies