How do I turn off autoformat for .CSV (comma delimited) files?

G

Guest

I have to load, edit then save a lot of .CSV (comma delimited) files, and I
need them saved back as .CSV files (not .XLS). Is there any way I can
permanently turn off the autoFormat function so that lead zeros are not
stripped off of zip codes and so forth?

Thanks!
 
G

Guest

Hi Mike-

The last step of the Text Import Wizard in Excel 2002 has an option to set
formatting for each column, including Text format.

That did not work?

PB
 

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 do I change a csv extension file to an xls file and use it? 1
How do I save an excel spreadsheet as a comma-delimited ASCII file 3
Comma Delimited (CSV) Files 1
a question about .CSV files 2
How can I save a 40meg 26,000 row file to Space Delimited format 1
How do I retain leading zero zip code formatting when saving as a. 7
Leading zeros disappear when saving as .csv 3
How is Excel Changing CSV File? 1

Top