Thread: Zip Codes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Zip Codes

One way is to format the cells CUSTOM as 00000.
--
HTH,
Barb Reinhardt



"Bill" wrote:

Hi. I understand how to allow o first digit zip codes, but I am importing
from my web site and I need to set up the 0#### condition "globally" for
Excel. Is there a way to do that?

Thanks!