Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
When I import my comma delimited file, the Text Import Wizard starts up. Using this wizard, Excel defaults the Data Format to "General". I want to use "Text" Data Format. Although the wizard allows me to change the Data Format column-by-column, it is tedious to do so. Is there a way to change all columns' Data Format at the same time? Or, to set the Text Import Wizard's default to a "Text" Data Format? Or, maybe there is another way to import data - I am not a super user, so I like using the wizard. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I import XML as text format | Excel Discussion (Misc queries) | |||
How do I rotate a text box | Charts and Charting in Excel | |||
Text Boxes | Excel Discussion (Misc queries) | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |