I encountered some trouble changing cell types in LibreOffice Calc from text to dates.
This happens when I import a CSV file. The import into rows and columns works fine. However, the dates are not recognized as such. When I try to change the cell type manually via "Format Cells..." to the appropriate date format Calc only prepends a '
to the cell.
Example: The text "19.03.24" reads "'19.03.24" after manually changing the cell format to date.
I suppose there is some "hidden" setting that prevents me from changing the cell type.