year changes when copied from one workbook to another
 

I receive a file from one department and copy the information into another
file. When I do this the date changes. It adds one day and four years to the
date. The options has the 1904 date system selected. When I turn this off the
dates come in correctly but the rest of my dates in the worksheet change.
What can I do?

Instead of changing your date system, put 1462 in a cell, copy it and select
the received dates, then do
editpaste special and select subtract, then reformat as dates

--

Regards,

Peo Sjoblom


"Pgarbarini" wrote in message
...
I receive a file from one department and copy the information into another
file. When I do this the date changes. It adds one day and four years to
the
date. The options has the 1904 date system selected. When I turn this off
the
dates come in correctly but the rest of my dates in the worksheet change.
What can I do?