Thank you all for your assistance. You have pointed to features of which I was not aware, but found easily. The work-around solution will not be necessary. As for not deleting the single quote that is not there, that work-around works, but is very labor intensive. I will be doing some experimenting to see the best way to implement your suggestions to import number and date and time data, but the preliminary test suggests that it works on dates in the mm/dd/yyyy mixed-endian format. Now to test it on the dd mmm yyyy big-endian and yyyy-mm-dd small endian formats which are the three main formats. Of all the formats, I have been using the small endian format since the sixties as it sorts properly even in text format. I was surprised when I found out that the International Standards Organization chose that format and called it ISO8601. Again, thank you all. 2012-09-01 51:59:28 Z-07 -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4004973.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@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