software

I need to open a number of tab delimited files in Excel 2003. Each row has a
number of columns, some have numeric data with leading zeros that need to be
imported as text. The default Wizard option for these columns is quot;Generalquot;
and it takes quite a bit of time going thru each column to change it to
quot;Textquot;. Is there a way to change the default column formating to quot;Textquot; so
when the Wizard runs, the column default is quot;Textquot; instead of quot;Generalquot;?

Thanks!

Turn on the macro recorder while you go through the steps.

You should get close to what you want, if not exactly.Gord Dibben MS Excel MVP

On Sat, 22 Apr 2006 19:25:02 -0700, SteveB gt;
wrote:

gt;I need to open a number of tab delimited files in Excel 2003. Each row has a
gt;number of columns, some have numeric data with leading zeros that need to be
gt;imported as text. The default Wizard option for these columns is quot;Generalquot;
gt;and it takes quite a bit of time going thru each column to change it to
gt;quot;Textquot;. Is there a way to change the default column formating to quot;Textquot; so
gt;when the Wizard runs, the column default is quot;Textquot; instead of quot;Generalquot;?
gt;
gt;Thanks!Another alternative if the columns that are text are contiguous.

When you're in the wizard, click on the left most text column and shift click on
the rightmost text column and then choose text.

If all the column fields are text (or can be treated as text), you can get them
all at once, too.

SteveB wrote:
gt;
gt; I need to open a number of tab delimited files in Excel 2003. Each row has a
gt; number of columns, some have numeric data with leading zeros that need to be
gt; imported as text. The default Wizard option for these columns is quot;Generalquot;
gt; and it takes quite a bit of time going thru each column to change it to
gt; quot;Textquot;. Is there a way to change the default column formating to quot;Textquot; so
gt; when the Wizard runs, the column default is quot;Textquot; instead of quot;Generalquot;?
gt;
gt; Thanks!

--

Dave Peterson


Originally Posted by SteveBI need to open a number of tab delimited files in Excel 2003. Each row has a
number of columns, some have numeric data with leading zeros that need to be
imported as text. The default Wizard option for these columns is quot;Generalquot;
and it takes quite a bit of time going thru each column to change it to
quot;Textquot;. Is there a way to change the default column formating to quot;Textquot; so
when the Wizard runs, the column default is quot;Textquot; instead of quot;Generalquot;?

Thanks!

Hey!

Check out TextConverter. There you just change the output column type and it should work.

Nikita