Can you share with those of us not familiar with web stuff an example or two
of what an "htlm format" date looks like?

--
Rick (MVP - Excel)


"Tigerxl" wrote in message
...
I copy paste around 2 thousand dates in a website ( htlm format ) into
my XL 2003, column A.
Now the formula (=text(A2,"ddd") does not reconize the format in those
dates.
How can I change those dates to date format in XL.
I tried formatcelldateMarch 14,2001 and it did not work.
THANK YOU.
PS I can not sort them either.