Ask Your Question

How do I change the default date/time format?

asked 2018-06-15 02:23:02 +0200

I prefer to use the default date of MMMM/DD/YY, (written as January 23, 2018), and the time of HH:MM:SS AM/PM.

I click on the Insert Field button, and I have to manually change the date and time format every single time, which I find very annoying. I can't find anywhere on how I am supposed to change it to default. There should be a way to change it to default, because now when I insert the time field it's formatted as HH:MM:SS (24hr)

I am trying to do this on LibreOffice Writer on version with the build ID of 1:5.2.7-1+rpi1+deb9u3

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-06-15 03:48:54 +0200

Mike Kaganski gravatar image

updated 2018-06-15 03:53:17 +0200

The default formats (date/time, currency, fixed/scientific/percent; in long/medium/short variants where applicable) depend on cell/field/... language, and are hardcoded in the corresponding locale data (see i18npool/source/localedata/data for the locale data definitions). They are not configurable (unless you rebuild LibreOffice).

You may want to create a macro to automate insertion of fields with desired format; please see this question for details.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-15 02:23:02 +0200

Seen: 17 times

Last updated: Jun 15