How to avoid date convertions when importing external web data?

C

Cokeat

I tried to import web data from excel, which basically a very great function.

However, once the original data format is like 12-2, 3-10, etc, excel will
automatically covert it to dates to Dec-2, Mar-10 on spreadsheet.
(an example: try import the NBA standing table from www.nba.com via
"Data-Import External Data-New web query")

Is there anyways to turn off this coversion before importing data? or any
other ways to work around?

Thanks a lot.
 
G

Gord Dibben

Cokeat

Data>Import External Data>New Web Query.

Type or paste in the URL www.nba.com

That site will open and give you yellow arrows to select what you
want.

Click on the Options button and checkmark Formatting>None Import<PRE>
blocks into columns and........... Disable Date Recognition.........

Hit Import.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import External Data 3
How to import external data into excel? 2
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
Importing web data to Excel 2003 1
Query via Import External Data doesn't reflect revised syntax 0
How to import web link and avoid frame? 3
Basic Question in Web Query...HELP!! 0
External web Data Multiple Sites 2

Top