How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Tom Your Own Question
Tom, Mac Support Specialist
Category: Mac
Satisfied Customers: 675
Experience:  8 years experience as a Mac administrator for a college
Type Your Mac Question Here...
Tom is online now
A new question is answered every 9 seconds

I use the Mac version of Office (Office for Mac 2004 version

This answer was rated:

I use the Mac version of Office (Office for Mac 2004 version 11.2.3).
I have found that if I copy an Excel spreadsheet with formatted dates and paste into another spreadsheet, the dates change.
Typically the pasted version using a format of mm/dd/yyyy, advances the "dd" by one day and the "yyyy" and by four years.

What is wrong?
HelloCustomerand thanks for using

Open Excel

Click on Excel in the top left and choose Preferences

Click on Calculation on the left

Check to see if you have 1904 date system checked. The standard is unchecked.

Microsoft has more information here about this.
Tom and other Mac Specialists are ready to help you