Format Numbers With Preceeding Zeros

[Dave Hawley]

If you ONLY want a single zero, regadless of the number of Digits, use a Custom Format on the cells like;

0#################

To produce results like;
01
012
0123
0124

If you want to Pad the cell numbers with zero's, use a Custom Format on the cells like;

000000

To produce results like;
000001
000012
000123
000124