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

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