What I am doing is customizing a spreadsheet for the data as the data is presented in so many different ways. The data is then imported to the spreadsheet using the tips and tricks so that the data will be entered correctly. I then move things around, reformat, etc until the spreadsheet data is compatible with the the master spreadsheet. Cut and paste to the master spreadsheet and sort to integrate the data and it is all done except for the analysis.
I will try the trick of importing the data from the clipboard. Thank you for that idea. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007034.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