Worked like a charm!!! That's a new one for the toolbox (never seen or used
that built-in function before).

Thank you!

QB





"Dave Peterson" wrote:

Select the column
Data|Text to columns
Fixed width (remove any lines that excel guessed)
Choose Date (ymd) on the third step)

Format the way you like.

Excel doesn't see your text "2008-Jan-10" as a date. That's why changing the
number format didn't change the displayed text.

Question Boy wrote:

I have a column which contains dates

2008-Jan-10

I have tried changing the cell format, but it has no effect. I have tried
using the Text(..,"yyyy-m-d"), but it has not effect. How can I change the
format so it is formatted like yyyy-m-d?

Thank you

QB

--

Dave Peterson