Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zip Codes starting with 0 in .csv
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! |
#2
|
|||
|
|||
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. On Wed, 9 Feb 2005 14:51:08 -0800, "vkushnerov" wrote: 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! |
#3
|
|||
|
|||
Thanks!
"Myrna Larson" wrote: 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. On Wed, 9 Feb 2005 14:51:08 -0800, "vkushnerov" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
zip codes starting with 0 | Excel Discussion (Misc queries) | |||
How do I create a .csv file? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |