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 :)