automatic conversion of text into date :(

[arnold_charming]

Hi!

I'm pasting some data from Web into Excel tables. But unfortunetlly,
Excel transforms text '2/10' into date 'october 2'. How to prevent this
from happening. Please help me, because I looked everywere but no luck

 

[Bill Kuunders]

format the cells as text before you paste the values in.