Date change with column paste
Solved/Closed
Related:
- Date change with column paste
- How to change a column to numeric in Excel? - Guide
- How to change date format in excel for entire column - Guide
- How to paste data in alternate blank columns in excel - Forum - Excel
- Excel VBA – In a column, change only cells that - How-To - Excel
- How to copy and paste a column in excel to another sheet - Guide
4 replies
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.
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.
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.
andrewsbkk007
Aug 30, 2008 at 08:59 AM
- Posts
- 7
- Registration date
- Thursday May 1, 2008
- Status
- Member
- Last seen
- February 24, 2009
Aug 30, 2008 at 08:59 AM
have you checked if your system time is properly set ?
it may be due to this and set it to the real date
it may be due to this and set it to the real date
Sep 26, 2008 at 09:58 AM
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!
Jul 26, 2010 at 05:06 PM
Sep 3, 2010 at 12:01 AM
Sep 9, 2010 at 06:40 PM