Date format

[SERCAN BOZKURT]

Date format is different is different in different countries and 09/10/09
may mean different things in different countries.

For some countries it means 10th day of the 9th month.
For some countries it means 9th day of the 10th month.

Excel interpretes such a date as the 10th day of the 9th month but I'm not
used to that.

I'd like excel to understand 09/10 as 9th day of the 10th month.

I tried a bit of things with international pane on the system preferences
and the cell content format but haven't succeed.

Any suggestions?

 

[CyberTaz]

Excel picks up the date information from the System Preferences, so you were
headed in the right direction... but did you have Excel running when you
made the changes there? The Prefs are read on start-up, so if Excel was
running when the changes were made those changes won't go into effect until
you re-launch the program.

If you continue to have a problem you'll need to indicate your exact
versions of Excel and OS.

 

[richardf]

Click or drag the cell(s) you want to format
Then:-
Menu Bar>Format>Cell>date>custom (Custom is last in the choices of formats)
In the type field type dd/mm/yy or dd/mm/yyyy if you want the year to
appear as four digits.
Dates entered in cells so formatted will show day/month/year.

P.S I'm still using coal-fired Excel Version 11.2!! (2004) Hope this method works for later versions!! Most "improvements" to excel aren't!!