View Single Post
  #1   Report Post  
Eamon
 
Posts: n/a
Default 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