How to avoid discrepancy when copy date?

B

Bill.liu

Iwhen I copy the date from one file to another ,the date changed.
For example:eek:riginal date is "May 24,2006" but it changed into "May 23,2002"
when I copy them from one file to another.And it always change the year from
other into 2002.
 
D

David Biddulph

Bill.liu said:
Iwhen I copy the date from one file to another ,the date changed.
For example:eek:riginal date is "May 24,2006" but it changed into "May
23,2002"
when I copy them from one file to another.And it always change the year
from
other into 2002.
Click to expand...

Look at Tools/ Options/ Calculation: 1904 date system. I presume that one
file has this set and the other unset.
 
Top