3 ms·
I just started LibreOffice Calc (the version distributed with the latest version of Ubuntu), chose a cell and entered "1-December-2014" The program tidied it t
by michaelt 12y ago
I just started LibreOffice Calc (the version distributed with the latest version of Ubuntu), chose a cell and entered "1-December-2014"
The program tidied it to 01/12/14 (I'm in the UK, presumably the field order is locale-dependent) then exported a CSV with the default settings. Voilia, I have a file with the date expressed as 01/12/14
My guess is this process only gets run once a year, so it's not been a high priority for automation, and someone's spreadsheet program is configured to work out two-digit years automatically.