Once I have the data imported into the spreadsheet, there are no problems with dates. It was the importation of the dates that caused the problem. As for date formats, I prefer ISO8601 as I was using that format in the sixties and I never stopped. I can accommodate any *unambiguous* date and time format. It is when the dates and time format becomes ambiguous that I have problems. I found a definition for 'AFAIK'; "All Fans Are Inane Koalas". The other definition I found is not fit to print.
-- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007131.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted