Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting 01 to display 2
- Thread starter bc3v5
- Start date
-
1
- #2
ProjEngKLS
Mechanical
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
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
-
1
- #3
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.
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
