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?