View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How to avoide data conversion when opening a text file?

You're not, by any chance, holding down the shift key when you hit "open",
having selected the file, are you?
http://support.microsoft.com/kb/214295

If the wizard isn't coming up through File/ Open and selecting the .txt
file, it might just be worth trying with Data/ Import External Data/ Import
Data.
That route apparently (in Excel 2000 & later) allows csv's to be opened
through the wizard without needing to rename from .csv to .txt, so it might
possibly resolve your problem too.
--
David Biddulph

"Vel" wrote in message
...

It's too late when you've finished the import. At step 3 of 3 in the
text
import wizard, each column has a header with its default format (probably
General).


Then the problem is that there was no wizard.
Excel just opens the file, and I get no access to any converting options.
I can't figure out how to make the wizard work.