Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Data-Import External Data-New Web Query-Options and selected Full HTML Formatting, Import <PRE Blocks into Columns, Treat Consecutive delimiters as one, Disable Date Recognition. Now when this is imported to the spreadsheet and I click on a hyperlink it will not open. What could be preventing this? If I copy from the web and past into excel the hyperlinks are working but it is changing some numbers to dates how can I prevent it from changing some numbers to dates? Any suggestions would be much appreciated. Eamon |
#2
![]() |
|||
|
|||
![]()
Any suggestions would be much appreciated.
Eamon "Eamon" wrote in message ... Hi, Data-Import External Data-New Web Query-Options and selected Full HTML Formatting, Import <PRE Blocks into Columns, Treat Consecutive delimiters as one, Disable Date Recognition. Now when this is imported to the spreadsheet and I click on a hyperlink it will not open. What could be preventing this? If I copy from the web and past into excel the hyperlinks are working but it is changing some numbers to dates how can I prevent it from changing some numbers to dates? Any suggestions would be much appreciated. Eamon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import Data into same cell | Excel Discussion (Misc queries) | |||
Import Data: on insert, shift data down and not right | Excel Discussion (Misc queries) | |||
Automatic Data Import | Excel Discussion (Misc queries) | |||
External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |