Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

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.

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.

problems.