Importing Text
Third step of Wizard select the columns and Column Data FormatText
You could record a macro to do this.
Gord Dibben MS Excel MVP
On Tue, 15 Jul 2008 09:06:37 -0700 (PDT), Snailspace
wrote:
Can I set up excel to import all my data as text columns instead of
general columns? The wizard almost always changes some of my data and
I would prefer to automate this process.
Thanks!
|