awesome,thanks On 30 July 2011 00:06, Regina Henschel <rb.hensc...@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%2bh...@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> <drsouma...@gmail.com> MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> -- 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