| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
zip codes without losing leading zero from csv
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zip codes without losing leading zero from csv
Maybe you could change your CSV generator to create data like:
="01234" mccafl wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zip codes without losing leading zero from csv
On Feb 28, 4:57 pm, mccafl wrote:
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. What would happen if you made the zip codes as text not as numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zip codes without losing leading zero from csv
How do I get excel to know that is it text without have the quotes show?
"Stan" wrote: On Feb 28, 4:57 pm, mccafl wrote: 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. What would happen if you made the zip codes as text not as numbers? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zip codes without losing leading zero from csv
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. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "mccafl" wrote in message ... How do I get excel to know that is it text without have the quotes show? "Stan" wrote: On Feb 28, 4:57 pm, mccafl wrote: 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. What would happen if you made the zip codes as text not as numbers? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zip codes without losing leading zero from csv
Rename the CSV file as .txt, and then Excel's text import wizard allows you
to specify the column as text. -- David Biddulph "mccafl" wrote in message ... How do I get excel to know that is it text without have the quotes show? "Stan" wrote: On Feb 28, 4:57 pm, mccafl wrote: 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. What would happen if you made the zip codes as text not as numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| losing the leading zero when merging zip+4 postal code | Excel Discussion (Misc queries) | |||
| formating zip codes with leading zero to print zero | Excel Discussion (Misc queries) | |||
| How do I get leading zeros in zip codes in a mail merge | Excel Discussion (Misc queries) | |||
| how do I input zip codes with a leading zero | New Users to Excel | |||
| How to export excel column into Access without losing the leading. | Excel Discussion (Misc queries) | |||
Linear Mode
