Copy/Paste Info from web format HELP

[Brian]

Howdy All,

I have copied some info from a webpage that is in a table and when I try to
paste it into Excel, info that is a range (i.e. 1-3, or 2-5) comes out in a
date format (i.e. 3-Jan or 5-Feb).

If I try 'Paste Special', I only have options for HTML, Unicode Text, or
Text.
If I try Unicode or Text, everything ends up in column A.

Is there a way to paste this info without the above formatting taking over?

Thanks,
Brian

 

[Peo Sjoblom]

Can you use the data>get external data>web query? There you can go into
advanced and check disable date recognition

 

[Brian]

Thanks Peo, worked great!

Can you use the data>get external data>web query? There you can go into
advanced and check disable date recognition


--

Regards,

Peo Sjoblom