software

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: www.excelforum.com/member.php...oamp;userid=30066
View this thread: www.excelforum.com/showthread...hreadid=497473You 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)quot;largeone59quot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; I found something on a web page that i'm trying to paste into excel.
gt; There are some cells that have rule book references structured like
gt; this: 2-4-3
gt;
gt; Excel is interpreting these rule book references as dates and would
gt; change numbers like the above example to dates like 2/4/2003
gt;
gt; How can i stop excel from doing this when i paste?
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; largeone59
gt; ------------------------------------------------------------------------
gt; largeone59's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30066
gt; View this thread: www.excelforum.com/showthread...hreadid=497473
gt;
could you tell me how to do both of those please??

thanks!--
largeone59
------------------------------------------------------------------------
largeone59's Profile: www.excelforum.com/member.php...oamp;userid=30066
View this thread: www.excelforum.com/showthread...hreadid=4974731. In excel 2003 which I am working with at the moment, datagt;import external
datagt;new 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 formatgt;cellsgt;number and
select text, click OK
then paste
--
Regards,

Peo Sjoblom

(No private emails please)quot;largeone59quot; gt; wrote
in message ...
gt;
gt; could you tell me how to do both of those please??
gt;
gt; thanks!
gt;
gt;
gt; --
gt; largeone59
gt; ------------------------------------------------------------------------
gt; largeone59's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30066
gt; View this thread: www.excelforum.com/showthread...hreadid=497473
gt;