dates changing!

[darre77]

I wanna copy and paste a column of dates (yyyy.mm.dd) from one sheet to
another, but the year keep changing from 2004 to 2000... Anyone know
why this is?

 

[Peo Sjoblom]

Look under tools>options>calculation and the 1904 date system, the one where
you paste it to uses windows and does not have 904 checked and the other
does. Put 1462 in a cell, format it as date, copy it, select the 2000 date
and do edit>paste special and select add or change the date system so both
have the same..

 

[darre77]

Thanks. That solved my problem