dates changing!

D

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? :confused:
 
P

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