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!