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 John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

When I copy a date, the date changes, adding a day and several

This answer was rated:

When I copy a date, the date changes, adding a day and several years. Why is this, and how can I stop it?

Hi,

 

Microsoft Excel has two different date systems, the 1900 and the 1904 date systems.

 

These dates systems can be found under Calculation Preferences. Change the checked boxes from 1900 to 1904 or vice versa, and it should fix the problem.

 

Hope this helps. Let me know if you have any questions

 



Edited by John D on 7/18/2010 at 3:10 PM EST
John D and 4 other Mac Specialists are ready to help you