Importing Text

S

Snailspace

Can I set up excel to import all my data as text columns instead of
general columns? The wizard almost always changes some of my data and
I would prefer to automate this process.
Thanks!
 
D

Dave Peterson

If you're really automating the process, record a macro when you specify each
field as text.

If you just want to make it a little quicker when you do it manually...
Select the first field (on step 3 in the xl2003 wizard)
then shift click on the last field
All the fields will be selected and you can specify text for all of them.
 
G

Gord Dibben

Third step of Wizard select the columns and Column Data Format>Text

You could record a macro to do this.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Importing Long Numbers as Text cells 1
skip columns when importing from text 1
Importing Large Text Files 1
Importing text files automaticly. 5
Repeatable Fixed Width Import 9
Is it possible to automate the importing of exporting text data? 1
Import text from Word Form to Excel 1
Import and Export Text data 2

Top