Import comma delimited text



When I import my comma delimited file, the Text Import Wizard starts up.
Using this wizard, Excel defaults the Data Format to "General". I want to
use "Text" Data Format.

Although the wizard allows me to change the Data Format column-by-column, it
is tedious to do so. Is there a way to change all columns' Data Format at
the same time? Or, to set the Text Import Wizard's default to a "Text" Data

Or, maybe there is another way to import data - I am not a super user, so I
like using the wizard.

Thanks for your help.

Frank Kabel

you could record a macro while doing this manually and use this macro

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