Zip Codes converted to csv files

  • Thread starter Thread starter lynne
  • Start date Start date
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?
 
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

How to convert OST to PDF? Simple Methods 4
Saving a CSV file from Excel with 0 in front of Zip code 10
Convert csv to Excel files 1
How do I retain leading zero zip code formatting when saving as a. 7
how do I change a csv extension file to an xls file and use it? 1
Excel CSV Files; Creating Of 3
Excel And Notepad 3
Zeros and csv files 18

Back
Top