Date and Currency Formatting

I am new to Libre Office and live in South African. The date format in my country is dd-mmm-yyy and the number/currency format is 1 000,00 (one thousand only). My language is set to English South Africa with the number format as ZAR R English South Africa. When formatting a number with decimal places the desired result for one thousand is 1 000,00 (not a period separating the Cents from the Rands) and the date format for 5 December 2025 displays as 12 May 2025. How can I correct this for all Calc Spreadsheets? I use an Apple Mac computer and not a Windows computer.

1 Like

Always enter (type-in) the dates in ISO format: yyyy-mm-dd. Then the Calc will RECOGNISE the date (the numeric value) properly, and then the applied style will reformat them as you have set it in the cell style.

1 Like

There seems to be some disagreement about correct South African locale settings.

https://www.localeplanet.com/icu/en-ZA/index.html

ask118974.ods (42.9 KB)

The filtered spreadsheet shows available locales with comma as decimal separator and non-breaking space as thousands-separator.

1 Like

See also ReleaseNotes/24.8

2 Likes