Thread: Zip Codes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default Zip Codes

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!


I not sure about importing from a website but when I import from other
sources and wish to keep leading 0's I just mark that column to be
imported as text. As long as your not doing any calculations on the
cells it shouldn't cause any problems.

gls858