How to turn off the automated dates in excel (when importing data)
 

Hi, do you know how to turn off the automated dates off when importing data?
I am importing survey results to excels (e.g. 3-5, 6-10) and my excel just
keeps on turning this data into dates (oct-6). This drives me crazy :) I have
already tried format cells in many ways.

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

How to turn off the automated dates in excel (when importing d
 

Thanks guys!

I was importing (by copy-paste) CSV data from the web page, then using text
to columns function to separate irrelevant data from relevant (orginal data
was in form xxxx;xxxx;yyy;6-10). And it was after this when it turned into
dates what ever I did. At the end I run out of time and just manually used
the replace function to get them into form I wanted. Not probably the wisest
way to do this...

s


"Gord Dibben" wrote:

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