On 09/01/2012 08:04 AM, JAMES MAJESKI wrote: > How do I get rid of the single quote format character so I can work with the > dates from imported cvs or xls files? > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907.html > Sent from the Users mailing list archive at Nabble.com. > James,
On the box with all the import options, at the bottom where you see the table click on the column with the date data in it. All the columns are marked standard, change the date one to the desired date format in the column type selector. -- Jay Lozier [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
