You can import it using a web query and turn off date recognition or try to
preformat as text the range where you paste this to

--
Regards,

Peo Sjoblom

(No private emails please)


"largeone59" wrote
in message ...

Hello,

I found something on a web page that i'm trying to paste into excel.
There are some cells that have rule book references structured like
this: 2-4-3

Excel is interpreting these rule book references as dates and would
change numbers like the above example to dates like 2/4/2003

How can i stop excel from doing this when i paste?

Thanks!


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