Australian date format DD-MM-YY returns MM-DD-YY in some cells. Is there a work-around to prevent this from happening?
The spreadsheet and work books were saved over from excel to trial Libreoffice, which so far I have been very impressed by.
First, there is no "trial LibreOffice". There are only full LibreOffice releases on the download page.
Second, what exactly do you mean by "returns MM-DD-YY"? Already existing dates are displayed such instead of DD-MM-YY? Or when entering a date the displayed date then has day and month swapped? Or ...?
When I say "trial Libreoffice" I mean "give-it-a-go" as an alternative to microsoft office 365 which I have been using since dot. In anycase, a bit more reading and I came across what I was looking for (see answer). It was a case of changing the default language across the entire workbook rather than within a selected cell range (>format cells) which seemed to find it difficult to decipher between mm/dd and dd/mm until I changed the default language to Australia.