Dear all,
my computer (Mac) language is English but I would like LO to show dates in Italian Format. Currently dates are shown as MM/DD/YY by default and I would like them to be DD/MM/YY instead. How can I do this?
Thanks!
Please test changing the regional setting on Menu/Tools/Options/Language settings/Locale - Locale setting to Italian
DD/MM/YY is not specific for Italy. It is used in many locales. Under Italian locales it is coded GG/MM/AA.
Your locale seems to be ‘English (USA)’. It is (next to) the only locale using MM/DD/YY by default. With ‘English (UK)’ the default date format would be as you want.
You can set the language for the respective cells to any locale you want. You may do so for the LibO application. You may also set the ‘Numbers’ format for the respective cells directly to DD/MM/YY. Or you can define a cell style set to this date format.
You should not choose the locale ‘Italian (Italy)’ if you don’t live/work in/for Italy because this is the only locale worldwide using a stubborn time format that causes problems in specific cases. It is the one locale not recognizing e.g. 11:30:45 if entered as a time. This in contradiction with the applicable standard ISO 8601.
You would also get the comma as the decimal separator with Italian locales. This is not bad, but do you want this?
Also: Consider to abandon 2-digit-year formats. They are ambiguos. A few people born in 1917 e.g. are still living. There are more cases where 2-d-y cause problems.
Thanks! Setting the locale to English UK solved my issue.
“Consider to abandon 2-digit-year formats.” - but how do you set a 4-digit-year as the default?