Diable excel macro for DATES

E

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
 
P

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
Click to expand...

--
Regards,

Peo Sjoblom

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