View Single Post
  #4   Report Post  
nikitab nikitab is offline
Junior Member
 
Posts: 4
Default

Quote:
Originally Posted by SteveB
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!
Hey!

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

Nikita

Last edited by nikitab : July 28th 06 at 04:03 PM Reason: Link not visible