You can select the column, and goto DataText to Columns, and click the Next
button on the first two screens of the dialog, and click the data button on
the Column data format and select a date style.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rook" wrote in message
...
When you get the custom dialog box where it says in the text field under
the
place where it says type: you put in the type you want i.e. "yyyy-mm-dd"

then click OK

"j.a. harriman" wrote:

I right-clicked on the cell and choose the "custom" type that you
mentioned
and it did nothing. I have also tried a number of the "Date" formats (by
right-clicking on the cell I want to change) - nothing.

Jeff

"rook" wrote:

Format-cells-custom-type:yyyy-mm-dd - ok

"j.a. harriman" wrote:

Hi,
I have a column "A" of "dates" in text of DDMMMYY format, such as
"30Mar98".

I either need to convert all the values in the existing column to
datetime
values (YYYY-MM-DD) or create a new column "B" that contains the
converteed
values.

How is this done?

Thanks.