View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveB
 
Posts: n/a
Default Can you change the Text Import Wizard column options

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 "General"
and it takes quite a bit of time going thru each column to change it to
"Text". Is there a way to change the default column formating to "Text" so
when the Wizard runs, the column default is "Text" instead of "General"?

Thanks!