On 17:02 Feb 8, 2005 Crystle Numan <[EMAIL PROTECTED]> wrote:
[importing CSV data with dates like YYYYMMDD]
>
>When you import the csv, do you do 
>Insert->Sheet? If you do, you will
>get more options.

This does not convert the dates properly in OOo 1.0.2. Try formatting the
cells as some kind of Date after the import is complete.


I sent the OP a Perl script that converts the dates into ISO format
(YYYY-MM-DD) so they will be imported properly.


--Tony


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to