number format with leading 0
 

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

number format with leading 0
 

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

number format with leading 0
 

Darby,

Enter the format for your cells in Format-Cells-Number-Custom-Type as
0#

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=487224

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