So let me just clarify, with both files confirmed as NOT using the 1904 date
system, if you copy a date from one to the other, the data changes?

What is the data you are copying, ie is it a formula? What if you hard wire
a date into your first workbook and then copy and paste into the second,
what happens then?

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


"robin l" wrote in message
...
You are onto something - but when the 2 spreadsheet have diff date
calculation (1904 vs not) , how can i get the info from the copy
spreadsheet
to past correctly? When I change both to the same date calculation - all
the
dates get corrupted even when I say past values only.

"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".