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.