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!

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!