1. In excel 2003 which I am working with at the moment, dataimport external
datanew webquery, type in the
URL, under options select disable date recognition, click OK then click
import. This is mainly if you want to import tables etc You can do the same
in previous versions at least including excel 2000

2. Select the range where you want to copy, do formatcellsnumber and
select text, click OK
then paste



--
Regards,

Peo Sjoblom

(No private emails please)


"largeone59" wrote
in message ...

could you tell me how to do both of those please??

thanks!


--
largeone59
------------------------------------------------------------------------
largeone59's Profile:
http://www.excelforum.com/member.php...o&userid=30066
View this thread: http://www.excelforum.com/showthread...hreadid=497473