Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date System"
option, which is likely to be the cause.

See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm

Regards
Ken.......................


"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.

Protection is off.

"Glenn" wrote:

robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.

Thanks,

Robin


Describe in some detail "not working" and "data gets corrupted".