Date change with column paste [Solved/Closed]

Ask a question shhhhane - Last answered on May 8, 2013 at 09:34 AM by pleb

Whenever I try to paste the dates and times from one spreadsheet to another, the dates changes from 2008 to 2004. Why won't the dates just hold when I copy and paste from one doc to another. I have excel 2004 for Mac.


plus moins
Seems that Excel for Mac uses a 1904 date system to calculate dates. Don't ask me why this is different, but you can change this for each file in the Preferences/Calculation pane. Simply uncheck the "1904 date system" setting.
Was this answer helpful?  
Helpedme- Sep 26, 2008 at 09:58 AM
I had the same issue, and this fixed it. Any idea how to make this a global change, since it seems that I can only change the active workbook preference and I will have this same issue on a continual basis.
juan-ito- Jun 5, 2010 at 06:54 AM
do you know how to do it in new macs? cant find the calculation pane under preferences. thanks!
Mindspin- Jul 26, 2010 at 05:06 PM
Thank You!!!
kimmy- Sep 3, 2010 at 12:01 AM
that was an easy fix! thanks! :)
tje- Sep 9, 2010 at 06:40 PM
That just saved me a few hours of correcting data. Thank you so much!
plus moins
Thanks so much, this WORKS!
plus moins
For people that have the mac file only and don't have either a Mac or Excel for Mac.
I don't have one on hand so I had to save the file as CSV and then reopen it.
Make sure you chose the right date format - if you have hours/minutes/seconds you might lose them.
plus moins
have you checked if your system time is properly set ?

it may be due to this and set it to the real date

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!