Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you change the Text Import Wizard column options
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 wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you change the Text Import Wizard column options
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: 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! -- Dave Peterson |
#4
|
|||
|
|||
Quote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Can you change the settings for an Import Wizard | Setting up and Configuration of Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Excel Text import wizard | Excel Discussion (Misc queries) |