Dave,

When I open it in notepad the zeros are there. When I save it as a text file
though they dissapear. I am saving it as a text file but it looks like an
Excel/CSV file rather than the notepad icon. Does this help?

Thanks,

--
Chuck W


"Dave Peterson" wrote:

How did you open that CSV file--did you use excel or did you use NotePad?

As an aside, If the zip code field is really numbers, you can give that column a
custom format of: 00000 instead of concatenating the leading 0's.




ChuckW wrote:

Dave,

Here is the whole process of what I did. I exported data out of worldship
in Excel. When I did this it stripped the leading zeros out of records of
zip codes that begin with a zero. I then added a bunch of missing
information such as phone numbers and e-mails. I save the zip code field as
a text field and then sorted by zip code and use the concatenate to add
zeros back in and then saved my excel file. I then saved it as a csv file
from Excel. I then opened this csv file and noticed that it had stripped
out the zeros from my zip codes. I can't seem to add them either.

Thanks,
--
Chuck W

"Dave Peterson" wrote:

How did you verify the zipcode format (for leading 0)?

Did you reopen the .csv file in excel or did you open the file in Notepad?



ChuckW wrote:

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

--

Dave Peterson


--

Dave Peterson