Previous Topic Next Topic

Date change with column paste

[Solved/Closed]
Report
-
 pleb -
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

4 replies

Answer 1 / 4

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.
93
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Report

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.
Report

Hi,
do you know how to do it in new macs? cant find the calculation pane under preferences. thanks!
Report

Thank You!!!
Report

that was an easy fix! thanks! :)
Report

That just saved me a few hours of correcting data. Thank you so much!
Answer 2 / 4

Thanks so much, this WORKS!
Answer 3 / 4

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.
Answer 4 / 4
Posts
7
Registration date
Thursday May 1, 2008
Status
Member
Last seen
February 24, 2009
 4
have you checked if your system time is properly set ?

it may be due to this and set it to the real date
Ask a question