Diable excel macro for DATES

[evo]

Hi,

everytime i copy and paste from a website in this format XX/YY
excel sees it as a DATE. how can i disable this feature..I just want t
paste it as its raw form of XX/YY. When i cut and paste it in my exce
and try to change the format by using TExt. it comes up with rubbis
numbers.

Thank

 

[Don Guillett]

try formatting, as text, before you import

 

[Peo Sjoblom]

I'm afraid that's not possible, wouldn't it be nice if there was an option
to turn that off?

Hi,

everytime i copy and paste from a website in this format XX/YY
excel sees it as a DATE. how can i disable this feature..I just want to
paste it as its raw form of XX/YY. When i cut and paste it in my excel
and try to change the format by using TExt. it comes up with rubbish
numbers.

Thanks

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)