View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Zip codes that begin with a zero...

If you want a leading zero not only for display but for some other reason
you need to format as text or precede entries with an apostrophe '
otherwise use the zip code format under formatting

--

Regards,

Peo Sjoblom

"Ofelia" wrote in message
...
I have a zip code that begins with a zero. I try to format the cell and it
appears to work, but it does not show the zero in the formula bar. Then

I'll
save it but when I reopen the worksheet it does not save it. Is there some
other way of doing this? Please Help!- Thanks