I though about that, but 10/1/08 doesn't convert to 4/2/03 for me when I go
between date systems...

October 1, 2008 becomes September 30, 2004
January 10, 2008 becomes January 9, 2004



Ken Wright wrote:
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
...
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".