We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

CALC: default date format [closed]

asked 2017-07-04 22:57:23 +0200

lovecraft22 gravatar image

updated 2020-10-09 11:46:26 +0200

Alex Kemp gravatar image

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?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 11:47:35.733004

2 Answers

Sort by » oldest newest most voted

answered 2017-07-05 01:02:11 +0200

Lupp gravatar image

updated 2017-07-05 01:05:01 +0200

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.

edit flag offensive delete link more


Thanks! Setting the locale to English UK solved my issue.

lovecraft22 gravatar imagelovecraft22 ( 2017-07-05 08:04:42 +0200 )edit

"Consider to abandon 2-digit-year formats." - but how do you set a 4-digit-year as the default?

MrP gravatar imageMrP ( 2018-10-10 23:54:59 +0200 )edit

answered 2017-07-05 00:35:53 +0200

m.a.riosv gravatar image

Please test changing the regional setting on Menu/Tools/Options/Language settings/Locale - Locale setting to Italian

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-04 22:57:23 +0200

Seen: 4,605 times

Last updated: Jul 05 '17