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

Top