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

On 29 July 2011 12:29, Koen van Steekelenburg
<koenvansteekelenburg@gmail.com> 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 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