close

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!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()