If you select (highlight) the columns into which you are pasting, and
Format Cells, set format to TEXT, and then Paste Special, Text your
cricket scores should remain intact.
Saxman Wrote:
Is there any way within Excel whereby I can disable date recognition?
I
often copy data from an HTML page and paste it into Excel. Even if I
select 'paste special'/'text', I still have problem with data like
10-12, and 5/6.
I can overcome this by importing data/new web query/options/disable
date
recognition, but it appears to be a bit long-winded compared to
copy/paste.
Thanks.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=392458