Zip Codes converted to csv files

L

lynne

Every time I convert my drop ship lists from .xls files
to .csv for import into UPS shipping software, the csv
file drops the preceding zero on the east coast zip codes.
How do I fix it?
 
B

Bob Phillips

Format the column as "00000" (or however many digits a zip code is)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving a CSV file from Excel with 0 in front of Zip code 10
zip codes not being saved as text in CSV format 5
Zip Codes starting with 0 in .csv 2
How do I retain leading zero zip code formatting when saving as a. 7
Access Importing csv daily files into access 2007 1
Convert csv to Excel files 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
How do I turn off autoformat for .CSV (comma delimited) files? 1

Top