Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving a CSV file from Excel with 0 in front of Zip code
Hi,
I am trying to import some addresses into UPS worldship software. I need it in the form of a CSV file. It does not accept excel as an import engine. I have several addresses with zip codes which start with zero. I am able to keep the zero in front of the zip code in Excel but when I go to save it as a CSV file it drops the zero. Worldship then rejects the record since it is not a valid address. I need to find a way to have a zip code which starts with a zero saved as a CSV file. Can anyone help? Thanks, -- Chuck W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 saving a file | Excel Discussion (Misc queries) | |||
How do I stop Excel from saving a file with a different name? | Excel Discussion (Misc queries) | |||
Using other workbooks.. | Excel Worksheet Functions | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |