On 29 July 2011 13:36, Regina Henschel <[email protected]> wrote:
> In the csv import dialog is a preview of the data. Click on the column > header of the date column. This enables the 'Column type' drop down list. > There choose 'Date(YMD)'. Now the dates should be recognized as date already > when importing the document. Yes, but I was under the impression that the spreadsheet already existed (was different from the CSV file) -- 'a document(csv converted to spreadsheet)' so did not assume that was an available option. Koen, if you are importing the CSV file from scratch, then setting the import filter is absolutely the way to do the conversion. If the file has already been imported and changes made, use either of the other two options provided. -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- 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
