annoying wrong dateformat

[ilgrauls]

I live in Belgium but have a UK installation on my Mac. When I type in 11/2 as in February, Excel changes it to 2/11 as in November 2nd.
My Formats are correct in 'International' in my System Preferences.

Any ideas? It's very annoying.

 

[Bob Greenblatt]

I live in Belgium but have a UK installation on my Mac. When I type in 11/2 as
in February, Excel changes it to 2/11 as in November 2nd.
My Formats are correct in 'International' in my System Preferences.

Any ideas? It's very annoying.

Have you restarted Excel since you made or verified the change? Try quitting
Excel change the system preferences to some other country, then change back
to the one you want, and then restart Excl and try again.

 

[Ilgrauls]

No that doesn't work. If I format the cells as dates, it only offers the possibiity 3/14 or 14-Mar and some others but not 14/3.
However, some experimenting led me to the solution. You have to format the cells as a "custom" format, namely dd/mm.

 

[Mark Clifton]

To get European time set on a mac go to System
Preferences
Date& time
Internaitonal
Formats
change region
Belgium
This will set your computer to Belgium mode.