View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Darby
 
Posts: n/a
Default number format with leading 0

Thanks

"Ron Coderre" wrote:

Try this:

FormatCellsNumber
Category: Custom
Type: 00
Click [OK]


Does that help?

***********
Regards,
Ron


"Darby" wrote:

Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.

Thanks