Thanks. Gord. First time to use this online discussion forum and found it's
quite efficient. I am still Excel beginner and far away to be a MVP :)

Regards/Wintersunshine from Shanghai


€œGord Dibben€�编写：

sunshine

Forgot to propose a fix.....

Select the dates and DataText to ColumnsNextNextColumn Data FormatDate.
Choose MDY and Finish.

Gord

On Tue, 4 Jan 2005 22:39:01 -0800, "wintersunshine"
wrote:

Hi,

If the date was input as mm/dd/yyyy (12/31/2004), can I convert the format
to "yyyy-mm-dd"(2004-12-31) or "mmm-yy"(Dec-2004)? i tried to change date
format from "Format Cells-- Number tab--Category--choose "date" or "custom"
but just failed.

While Strangely, If i imput the data as "2004-12-31", i can change it to
whatever date format i like.

Appreicate your advice at earliest convenience.

Thanks