Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross 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

Status
Not open for further replies.
bc3v5

bc3v5

Computer
Jan 15, 2003
5
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?
 
Replies continue below

Recommended for you

Sort by date Sort by votes
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Denial
  • Locked
  • Question
Early alternative to ISFORMULA() function 1
2
Replies
20
Views
2K
3DDave
3DDave
rb1957
  • Locked
  • Question
opening links (to other workbooks) ? 1
Replies
19
Views
1K
IRstuff
IRstuff
3DDave
  • Locked
  • Question
Only 30 years to fix this
Replies
5
Views
800
SkipVought
SkipVought
vinodnx7
  • Locked
  • Question
Micro to compare two excel file for mirror change
Replies
4
Views
856
vinodnx7
vinodnx7
skeletron
  • Locked
  • Question
Footers and Page Break boundaries with print-to-PDF
Replies
3
Views
290
3DDave
3DDave

Part and Inventory Search

Sponsor

Back
Top Bottom