Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
How can I check if data in an external data range is changed afte. | Excel Worksheet Functions |