Problem with dates in Excel 2004 MAC
Solved/Closed
Related:
- Problem with dates in Excel 2004 MAC
- A little to the left free download mac - Download - Puzzle
- Psiphon for mac - Download - VPN
- Backslash mac - Guide
- Cuphead download mac - Download - Shooters
- Number to words in excel - Guide
5 responses
Szimitar
Posts
1
Registration date
Wednesday December 17, 2008
Status
Member
Last seen
December 18, 2008
6
Dec 18, 2008 at 12:10 PM
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
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Dec 18, 2008 at 03:37 PM
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 :)