Getting 01 to display 2

[bc3v5]

This might seem trivial...but does anyone know how to get 01 to diplay in the cell when the cell is formated as a Number?

 

[ProjEngKLS]

One way is to use a custom format

0#

The single digit numbers 1 through 9 will display with leading 0.

This way, the cell is still a numerical value - so it can be used in calculations.



ProjEngKLS

 

[dsi]

Set a custom format of 00.### and it will always display two number with up to 3 decimal places. The 0 dictates the value will be shown and # dictates the number will be shown if it exists. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

[bc3v5]

THANK YOU!!!!