How to avoid date convertions when importing external web data?

G

Guest

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 - web query 3
Excel Import External Data by Date Automatically 0
Import External Data 3
Importing web data to Excel 2003 1
Excel 2003 - Importing External Data - formatting problem? 2
Importing several web pages with macro/VBA? 9
How to import external data into excel? 2
Import external data problem 1

Top