On 29 July 2011 12:29, Koen van Steekelenburg <[email protected]> wrote:
> 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. Assuming the YYYYMMDD is in cell A1, I would use =DATEVALUE(CONCATENATE(LEFT(A1,4),"-",MID(A1,5,2),"-",RIGHT(A1,2))) -- 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
