| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert tab delimited files to pipe delimited? | Excel Discussion (Misc queries) | |||
| Importing a part of a big comma delimited csv-file | Excel Worksheet Functions | |||
| Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) | |||
| Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
| HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
Linear Mode
