How to add a zero infront of a number
Thanks for your help.
"RobN" wrote:
But if you want it to still behave as numeric, you could apply the custom
format of "0"0 to those cells.
Rob
"CYNTHIA" wrote in message
...
this is fast and works
"Mike Rogers" wrote:
CYNTHIA
Place an apostrophe first then your number (the apostrophe will not show
on
the sheet but will be seen in the formula bar), or formate the cell as
text.
Mike Rogers
"CYNTHIA" wrote:
How do I add a zero infront of a number.
For example I want the number to be read like this:
012
But i type in excel it shows up as 12.
|