I have imported a CSV into LibreOffice Calc and some columns are in human-readable form (notably dates and currencies). Those are imported as text, but this way I cannot do anything useful with them, like graphing.
One columns has dates like this:
26 May 2017 13:38:11
and currency like this:
How can I translate those into machine-readable formats?