How to avoid discrepancy when copy date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Iwhen I copy the date from one file to another ,the date changed.
For example:original 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.
 
Bill.liu said:
Iwhen I copy the date from one file to another ,the date changed.
For example:original 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to avoid discrepancy when copy the date from one file to anoth 2
Copying Dates 2
Date changes from copy to paste 1
Compare dates to copy data 4
Dates changing 5
When I copy cells in Excel they go to my printer. How can i stop . 1
copy date in a cell if within a date range 1
Why do dates change when I copy/paste into another sheet? 1

Back
Top