LibreOffice Calc - do not apostrophe-escape dates when opening a file
After changing the system locale, you can select a column, set the correct date format, then run the menu item Data » Text to Columns.
After changing the system locale, you can select a column, set the correct date format, then run the menu item Data » Text to Columns.