| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep leading zeros and format my cells as text?
I've formated the cells to have leading zeros using the custom category. But
I as need to format the cells to text. How do I accomplish both? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep leading zeros and format my cells as text?
Try putting an apostrophe before the number, as in '0.50.
-- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "BlabberLots" wrote in message ... I've formated the cells to have leading zeros using the custom category. But I as need to format the cells to text. How do I accomplish both? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros in text format | Excel Discussion (Misc queries) | |||
| Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
| Format a cell to keep leading zeros. | New Users to Excel | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
Linear Mode
