You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I prefer to use the dd/mm/yy date format. At a certain point, Excel stopped allowing dates to be inputted in that format. While I can still have them displayed as dd/mm/yy, I have to input them as mm/dd/yy or Excel will not interpret them correctly. Do other people have this problem? Thanks!
MacBook Pro 14″, macOS 14.5
Excel is not an Apple application and you should be asking survey questions in the specific Microsoft Excel community for Mac users.
Well, under normal (pre-glitch) conditions, the format I set for the date is used both for input and for display. So if the date format is dd/mm/yy and I type in 09/10/99, Excel interprets that dates as 9 October 1999 and displays it as 09/10/99.
After the fateful update, the format I set for the data only works for the display, whereas Excel interprets all input dates as mm/dd/yy. If I again type in 09/10/99, it reads it as 10 September 1999 and displays it as 10/09/99.
The issue here is that if I have specified a date format of dd/mm/yy, I expect to be able to input my dates as dd/mm/yy. Excel suddenly stopped letting me do that.
I have to input them as mm/dd/yy or Excel will not interpret them correctly. Do other people have this problem? Thanks!
How would it know if you meant 09/10/99 or 09/10/99?
Oops, thank you!
From your description it appears Microsoft changed something. You should contact them.
Yes, you're right (I'm new here). I posted my question in the Microsoft community for Mac users. Thanks.
Excel date input format
