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.
_______________________________________________
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Reply via email to