When I import a
.csv that contains a date field into LibreOffice Calc, and I set that column to DATE the content is prefixed with a single quote (
'). That's annoying because I can't use functions on it: the single quote makes Calc use the content as free text.
To remove the single quote, select the column with dates and do a search and replace (
CTRL + H): search for
^.*$ and replace it with