[libreoffice-users] How to convert a number(in format YYYYMMDD) to date

[Koen van Steekelenburg <koenvansteekelenburg@gmail.com>]

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.

Kind regards,
Koen

-- 
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