Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cokeat
 
Posts: n/a
Default How to avoid date convertions when importing external web data?

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How to avoid date convertions when importing external web data?

Cokeat

DataImport External DataNew 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 FormattingNone Import<PRE
blocks into columns and........... Disable Date Recognition.........

Hit Import.


Gord Dibben MS Excel MVP


On Tue, 10 Jan 2006 12:26:02 -0800, Cokeat
wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 01:45 PM
Get External Data in Excel MattsConfused Excel Discussion (Misc queries) 0 December 17th 05 06:37 PM
Excel: Use a name with external workbook reference for data valida Fishyken Excel Worksheet Functions 3 March 11th 05 11:24 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 03:45 AM
How can I check if data in an external data range is changed afte. Ruud Excel Worksheet Functions 0 January 7th 05 01:15 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"