[Libreoffice-qa] Calc date conversion

jafaucett faucett at lanl.gov
Tue Feb 28 15:45:49 UTC 2017

When pasting in some lines with a date, the year 2017 gets converted to 2021
when "Detect special numbers" checked in the dialog that pops up.  Example:

2/01/2017 04:29:17 Reading 1
2/01/2017 04:35:45 Reading 2

becomes the two columns

02/02/21 04:29 AM     Reading 1
02/02/21 04:35 AM     Reading 2

What setting will produce the correct date on conversion?

View this message in context: http://nabble.documentfoundation.org/Calc-date-conversion-tp4209166.html
Sent from the QA mailing list archive at Nabble.com.

More information about the Libreoffice-qa mailing list