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

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!

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

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

"Mike Schwartz" wrote:

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!