Date entry not respecting my locale / Region

[fre]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

Excel seems not to respect the system-wide region settings (System Preferences -> International -> Formats) for date entry AND display. I've looked myself silly in the preferences pane, but couldn't find anything to correct this.

I live in Belgium and for example the date format here is dd/mm/yy while Excel always defaults to mm/dd/yy. This is very inconvenient on data-entry.

Also on display it seems to use a hard-coded US format, but at least there I can solve it with a custom format.

Your help and/or hints would be greatly appreciated!

Many thanks,

Frederik.

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,

Excel seems not to respect the system-wide region settings (System Preferences
-> International -> Formats) for date entry AND display. I've looked myself
silly in the preferences pane, but couldn't find anything to correct this.

I live in Belgium and for example the date format here is dd/mm/yy while Excel
always defaults to mm/dd/yy. This is very inconvenient on data-entry.

Also on display it seems to use a hard-coded US format, but at least there I
can solve it with a custom format.

Your help and/or hints would be greatly appreciated!

Many thanks,

Frederik.

First thing to know, is that Excel reads the System Preferences only when it
starts, so if you make experiments with the date formats you have to quit
Excel each time you make a change to see its effect.

Instead of using the default Belgian format, have you tried the Personalized
setting at the bottom of the areas list? It seems to work better.

JL
Mac OS X 10.4.11
Office v.X 10.1.9