Ask Your Question

default date output other than MM/DD/YY in calc

asked 2015-05-29 06:36:11 +0200

azam gravatar image

updated 2015-08-26 20:05:24 +0200

Alex Kemp gravatar image


I am using Libreoffice, en-my locale.

I know that we can change the input format (date acceptance pattern) and change the cell format for individual cell/group of cells. but the rest of the world other than the US is using other date format. so instead of changing the format every time, we should be able to change default with permanent effect. this concerns the display in the cell as well as formula bar.

please advise if this feature has already been included.

thank you.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-05-29 11:44:12 +0200

Lupp gravatar image

updated 2015-05-29 12:02:25 +0200

If you change your locale (> 'Tools' > 'Options' > 'Language Settings' > 'Languages') to 'English (UK) ' the default date format will be D/M/YY'. That's also bad, as any date format wit 2-digit-year, but surely might meet your needs better than the Belize format. The disadvantage: The default currency will be the GBP ("£") then.

The good news: The setting is independent of the UI language and of the document settings.

I did not yet succeed finding a way by "reverse engineering" allowing for different locale settings with regard to currency and dates respectively manipulating the user profile. (I think it should be feasible, however.)

edit flag offensive delete link more


And even more, it's possible to select a specific language for every by style or by cell.

m.a.riosv gravatar imagem.a.riosv ( 2015-05-30 00:05:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-29 06:36:11 +0200

Seen: 1,765 times

Last updated: May 29 '15