1

I have a string 19 Jan 1819 and want to get it back in the ISO 8601 format 1819-01-19. Is there a function in LibreOffice calc that does this conversion?

Improve this question

1 Answer 1

Reset to default
-1

Instead of using a function, it is easier to go to Data -> Text to Columns. In the dialog window, select the cell to convert, then change the column type to Date (DMY).

Complete instructions are at http://cca220v.net/blog.php/2012/12/20/convert-cells-from-text-to-date-libreoffice.

Improve this answer
1
  • This seems to handle fields that don't contain months and days poorly.
    – Christian
    Sep 26, 2016 at 14:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .