import web data; end up wrong format in excel

**Exxcel Noob** · 05-26-2012, 07:53 PM

http://img708.imageshack.us/img708/4823/errornf.png

Hello everyone, I tried to imported statistic data into excel, but when I imported the format changed.

I boxed the column in red, orange and green as you can see.

I also try to reformatted into text ONLY, and when I pressed the refresh button it return to original.

Does anybody have any idea how to resolve this?

Thank you

**FDibbins** · 05-26-2012, 08:19 PM

probably a redundant comment, but its seeing some of that data as dates. when you click on 1 of those cells, what does the content show?

**Cutter** · 05-26-2012, 08:56 PM

Right click anywhere within the imported values. Choose Edit Query so that the Web Query window pops up (showing the site that your data is from).
In the top right corner is a button called Options. Click it and then check the "Disable Date Recognition" option.

**Exxcel Noob** · 05-27-2012, 11:40 AM

Originally Posted by Cutter

Right click anywhere within the imported values. Choose Edit Query so that the Web Query window pops up (showing the site that your data is from).
In the top right corner is a button called Options. Click it and then check the "Disable Date Recognition" option.

thank you so much Cutter !