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 |