Hi
sounds like your imported dates are not recognised as 'date' values but are
stored as 'Text'. One possible workaound:
- select your date values
- goto 'Data - Text to columns'
- just step through the wizard and Excel should convert them to real date
values

--
Regards
Frank Kabel
Frankfurt, Germany

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