Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zip Codes from excel to .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
|
|||
|
|||
Not sure I can help, but your post got me curious. When I save an Excel file
containing both zip code formatted numbers and the equivalent in text format, then opened the .csv with Notepad, the leading zeros came through from both formats. Opening the same .csv with Excel stripped the zeros from both, and left them in the General format. What program are wanting to import the .csv into? "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
|
|||
|
|||
Excel preserves leading zeros when saved in CSV format. You should see this
if you open the file in Notepad. Opening the CSV in Excel is not a good test because, as IanRoy said, Excel strips off leading zeros. -- Jim Rech Excel MVP "vkushnerov" wrote in message ... |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! | |
#4
|
|||
|
|||
I needed the .csv to import the data into SalesForce - a Customer
Relationship Manager on steroids. I guess my problem was that I woudl reopen the .csv in excel and not in textpad or notepad. Thanks to both of you who replied. "IanRoy" wrote: Not sure I can help, but your post got me curious. When I save an Excel file containing both zip code formatted numbers and the equivalent in text format, then opened the .csv with Notepad, the leading zeros came through from both formats. Opening the same .csv with Excel stripped the zeros from both, and left them in the General format. What program are wanting to import the .csv into? "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 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Zip Codes starting with 0 in .csv | Excel Discussion (Misc queries) | |||
Excel doesn't sort zip codes properly | Excel Discussion (Misc queries) | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) | |||
Bar Codes in Excel | Excel Discussion (Misc queries) |