Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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) |