Date change with column paste
Solved/Closed
Related:
- Date change with column paste
- Change computer name cmd - Guide
- Facebook date of birth change - Guide
- Change lg tv name - Guide
- How to change date format in excel - Guide
- How to change date in whatsapp - Guide
4 responses
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
Posts
7
Registration date
Thursday May 1, 2008
Status
Member
Last seen
February 24, 2009
4
Aug 30, 2008 at 08:59 AM
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