Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do some dates turn to ###### | Excel Discussion (Misc queries) | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing dates and military time from Excel into word doc mail me | Excel Discussion (Misc queries) | |||
How do I turn off auto-correcting dates | Setting up and Configuration of Excel | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) |