Date change with column paste Solved/Closed

Question

Hello,


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.

Thanks,

-Shane

peggyM · Accepted Answer

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.

andrewsbkk007 · Answer

have you checked if your system time is properly set ?

it may be due to this and set it to the real date

ango · Answer

Thanks so much, this WORKS!

Daisy · Answer

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.

Date change with column paste

4 responses

Similar discussions

Subscribe To Our Newsletter!