Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following problem.
I'm not able to modify all dates older than the day 13.

For example:
With the date 07/01/2013 11:20:00 I am able to change the format. To 07/01/2013 11:20 a.m.
But with 07/13/2013 00:00:00 or over the 13, I'm not able to change it to anything.

Even if I manually change the format, the date won't change.
Do you know what could be wrong?
Thanks

share|improve this question
3  
Check you locale settings. Your Excel setup is using DD/MM/YYYY format, which is common outside the US. –  Mike Fitzpatrick Aug 15 '13 at 1:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.