awesome,thanks On 30 July 2011 00:06, Regina Henschel <rb.henschel@t-online.de> wrote:
Hi Koen, Koen van Steekelenburg schrieb: Dear readers,I have a document(csv converted to spreadsheet) with bankstatements. Those statements have a date in the form of YYYYMMDD (no /'s or -'s). The problem is that I can't make libreoffice recognise those numbers as dates. Can somebody explain how I can make Libreoffice recognise the YYYYMMDD numbers as dates.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. Kind regards Regina -- Unsubscribe instructions: E-mail to users+help@global.libreoffice.**org<users%2Bhelp@global.libreoffice.org> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette <http://wiki.documentfoundation.org/Netiquette> List archive: http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> All messages sent to this list will be publicly archived and cannot be deleted
-- Dr soumalya ray <http://drsoumalya.blogspot.com> <drsoumalya@gmail.com> MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> -- 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