Problem with dates in Excel 2004 MAC
Solved/Closed
Related:
- Problem with dates in Excel 2004 MAC
- How to use if function with dates in excel - Guide
- How to format dates in excel - Guide
- How to convert number to words in excel in mac - Guide
- How to check author of excel file mac - Guide
- Calculate Time Between 2 Dates in Excel - How-To - Excel
5 replies
Szimitar
Dec 18, 2008 at 12:10 PM
- Posts
- 1
- Registration date
- Wednesday December 17, 2008
- Status
- Member
- Last seen
- December 18, 2008
Dec 18, 2008 at 12:10 PM
Found the answer.
There is a default setting in excel preferences to use 1904 date formatting.
Just uncheck that and dates are the same
.
There is a default setting in excel preferences to use 1904 date formatting.
Just uncheck that and dates are the same
.
aquarelle
Dec 18, 2008 at 03:37 PM
- Posts
- 7118
- Registration date
- Saturday April 7, 2007
- Status
- Moderator
- Last seen
- July 29, 2022
Dec 18, 2008 at 03:37 PM
Hi,
Thank you for coming back to give us the solution you have found. You can be sure that this will be helpful.
Best regards
Thank you for coming back to give us the solution you have found. You can be sure that this will be helpful.
Best regards
Awesome! I was just on the verge of having exploded head syndrome, when I found your solution doing a Yahoo search.
Thanks!
Thanks!
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.
Didn't find the answer you are looking for?
Ask a question
Hi,
Was just reading this post and thought I would add my 2c's. If you're struggling with this in excel chances are you will struggle with t all over the place.
In OS X Go to system preferences>date & time. Hit the format tab. Then click on international settings. Check out whether its US. Then if there is change it to your reigon. Fixed....across the board :)
Was just reading this post and thought I would add my 2c's. If you're struggling with this in excel chances are you will struggle with t all over the place.
In OS X Go to system preferences>date & time. Hit the format tab. Then click on international settings. Check out whether its US. Then if there is change it to your reigon. Fixed....across the board :)