Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What does the $ infront of a cell indicate in a calculation mean? | Excel Discussion (Misc queries) | |||
Add a number infront of a number | Excel Discussion (Misc queries) | |||
automatic multiple insertion of 0 infront of a tel number? | Excel Discussion (Misc queries) | |||
How do I format a cell so there can be a zero infront of a # (04) | Excel Discussion (Misc queries) | |||
how to have numbers add/sub without putting = infront | New Users to Excel |