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!
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
quot;Mike Schwartzquot; wrote:
gt; I have to load, edit then save a lot of .CSV (comma delimited) files, and I
gt; need them saved back as .CSV files (not .XLS). Is there any way I can
gt; permanently turn off the autoFormat function so that lead zeros are not
gt; stripped off of zip codes and so forth?
gt;
gt; Thanks!
- Apr 13 Sun 2008 20:43
How do I turn off autoformat for .CSV (comma delimited) files?
close
全站熱搜
留言列表
發表留言