Turning off date formatting

L

largeone59

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 lik
this: 2-4-3

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

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

Thanks
 
P

Peo Sjoblom

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)
 
P

Peo Sjoblom

1. In excel 2003 which I am working with at the moment, data>import external
data>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 format>cells>number and
select text, click OK
then paste



--
Regards,

Peo Sjoblom

(No private emails please)
 
Top