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

2011/7/29 Regina Henschel <rb.henschel@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+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