zip codes without losing leading zero from csv

M

mccafl

I create text files (csv) from Informix 4gl and I often need to send
zipcodes. When csv files open in excel, you lose the leading 0 for states
like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
can't depend on users to change the formatting of the cells.
 
S

Stan

I create text files (csv) from Informix 4gl and I often need to send
zipcodes. When csv files open in excel, you lose the leading 0 for states
like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
can't depend on users to change the formatting of the cells.
Click to expand...

What would happen if you made the zip codes as text not as numbers?
 
E

Earl Kiosterud

Stan,

If you see the zeroes on the sheet before you write the file as csv, it's probably including
them in the file. Open it with NotePad to see for sure.
 
D

David Biddulph

Rename the CSV file as .txt, and then Excel's text import wizard allows you
to specify the column as text.
 

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 stop Excel from automatically truncating leading zeros 2
leading zero & .csv files 4
Leading Zero dropping off after export to Excel 3
mail merge in excel/losing leading zero 1
CSV formatting issue 1
Formatting different zip code types within a column 4
losing the leading zero when merging zip+4 postal code 1
Importing to Excel from csv AND keep leading zeros 2

Top