View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to turn off the automated dates in excel (when importing data)

And if you're importing using a Web Query you can set it under Options to not
turn those into dates.

Web Query dialogOptionsDisable date recognition.


Gord Dibben MS Excel MVP


On Tue, 3 Jul 2007 09:16:06 -0700, "Peo Sjoblom" wrote:

How do you import it? You can import it as text. If you import a text file
use the text import wizard and in step 23 select the column and under column
data format select text