Thread: Importing Text
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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!