6 digit number with leading zeroes

  • Thread starter Thread starter Vinnie
  • Start date Start date
V

Vinnie

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
 
Hi Vinnie,

Enter 000000 as the Custom Format via Format Cells.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
1. Select the column or range you want to format
2. click Format--Cells--Number--Custom
3. Click the zero under General
4. In the Type box enter 6 zeros

ok
:)
 
Vinnie,

Just set the cell format to Custom and in the Type box set
the format to 000000
 
Back
Top