Import Data Problem
 

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

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