Saving a CSV file from Excel with 0 in front of Zip code

Giganews Newsgroups
Subject: Saving a CSV file from Excel with 0 in front of Zip code
Posted by:  ChuckW
Date: Thu, 8 Jun 2006

Hi,

I am trying to import some addresses into UPS worldship software.  I need it
in the form of a CSV file.  It does not accept excel as an import engine.  I
have several addresses with zip codes which start with zero.  I am able to
keep the zero in front of the zip code in Excel but when I go to save it as a
CSV file it drops the zero.  Worldship then rejects the record since it is
not a valid address.  I need to find a way to have a zip code which starts
with a zero saved as a CSV file. Can anyone help?

Thanks,

--
Chuck W

Replies