Lin,

The ways you can read a text file in Excel varies with the version. Take a
look at www.smokeylake.com/excel. Read up on Text files.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Lin" wrote in message
...
Hello,
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
Format?

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.