Zip Codes starting with 0 in .csv

V

vkushnerov

I have an excel spreadsheet that I need to convert to a .csv to import. One
of the columns is the zip code, including codes that start with 0. However,
whenever I convert it to .csv, it strips out the first 0 of the zip code,
thus leaving a 4 digit code. Is there a way to fix this?

Thanks!
 
M

Myrna Larson

It is NOT stripped out of the CSV file (you can check that in Notepad). The
leading 0 is stripped out when the CSV file is read back into Excel.
 
V

vkushnerov

Thanks!
Myrna Larson said:
It is NOT stripped out of the CSV file (you can check that in Notepad). The
leading 0 is stripped out when the CSV file is read back into Excel.
Click to expand...
 

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

Formula to add spaces in csv 4
Leading 0 in Mail Merge document 5
Zip Code formatting problem 3
Zip Codes from excel to .csv 3
How do I zip sort mailing list when I have 5 digit AND 9 digit zip 1
Saving a CSV file from Excel with 0 in front of Zip code 10
format cells as zip code not working 3
look up zip code 4

Top