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

Mr. Valentine is right. The document consists of imports of several
differently formatted csv-files and added personal notes, so reimport is no
option.

Koen

On 29 July 2011 21:10, T. R. Valentine <trvalentine@gmail.com> wrote:

> On 29 July 2011 13:36, Regina Henschel <rb.henschel@t-online.de> wrote:
>
> > 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.
>
> Yes, but I was under the impression that the spreadsheet already
> existed (was different from the CSV file) -- 'a document(csv converted
> to spreadsheet)' so did not assume that was an available option.
>
> Koen, if you are importing the CSV file from scratch, then setting the
> import filter is absolutely the way to do the conversion. If the file
> has already been imported and changes made, use either of the other
> two options provided.
>
>
>
> --
> 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

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