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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 0 in front of a number.
- Thread starter JJeremy
- Start date
BlueHorizon
Instructor
Hi,
Format the cell or column as text (Format/Cells/Number tab/ Category = Text.
You won't be able to use it in a calculation but you will be able to see the leading zeroes.
HTH,
Best,
Blue Horizon![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
Format the cell or column as text (Format/Cells/Number tab/ Category = Text.
You won't be able to use it in a calculation but you will be able to see the leading zeroes.
HTH,
Best,
Blue Horizon
format as text
or
use =text(a1,"000")
where the data is in cell A1
or
use a format of 000
3rd option will mean that the data is treated as a number. 1 and 2 will mean it is treated as text
Rgds, Geoff
Three things are certain. Death, taxes and lost data. DPlank is to blame
Please read FAQ222-2244 before you ask a question
or
use =text(a1,"000")
where the data is in cell A1
or
use a format of 000
3rd option will mean that the data is treated as a number. 1 and 2 will mean it is treated as text
Rgds, Geoff
Three things are certain. Death, taxes and lost data. DPlank is to blame
Please read FAQ222-2244 before you ask a question
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question