2011/7/29 Regina Henschel <rb.hensc...@t-online.de>: > 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 >
Wow, that sounds convenient! I didn't know about that! Sorry for giving a far too complicated answer, when it could be solved that easily. On the other hand, learning regular expressions may come handy in many other situations… Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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