LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import comma delimited text Lin Excel Discussion (Misc queries) 3 July 28th 06 04:07 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Can you change the settings for an Import Wizard mstack Setting up and Configuration of Excel 1 November 16th 05 11:32 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Excel Text import wizard Kate Excel Discussion (Misc queries) 1 February 23rd 05 06:40 PM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"