Date changes when copying to a new workbook

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

Guest

Dates are entered in an existing workbook hardcoded using the date format (no
formula). When I copy this sheet into a new workbook, all dates change to a
date 4 years and 1 day earlier then what was previously entered. I have
copied many worksheets and this is the first time I have seen this happen.
 
Back
Top