Thread: Numbering
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Numbering

enter

'01
'02

instead of 01, 02

the single quote tells excel to treat the entry as text and it won't remove
the leading zero.

An alternative is to format=Cell=Number tab, then select custom and enter
00

--
Regards,
Tom Ogilvy

"ecm" wrote in message
news:p7a4f.27476$S4.23411@edtnps84...
I am setting up a workbook where I would like to label series of vinyl
windows starting at 01, 02, 03 etc.

How do I do this? It keeps reverting back to 1, 2, 3.

TIA,

Eric