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/