data changes to date format

[keybrook]

Hi all, sorry if i'm repeating something that has allready been covere
but I can't find it anywhere on the forums.

I've got a problem with excel automatically changing numbers that I cu
and paste from the web into date's

For example the the data in a cell may be "5/2" and I want it to remai
as this but excel thinks it's a date and changes it to "5-Feb" (Anothe
example would be "10/11" being changed to "10-Nov")

I can't change the format of the source data as this is cut and past
directly from a web page, is there anything I can do to turn off thi
auto format feature?

Thank

 

[Rob van Gelder]

Format the cells as Text

Paste Special as Text instead of the standard Paste.