View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JoAnn Paules JoAnn Paules is offline
external usenet poster
 
Posts: 11
Default 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!