Changing dates to date format
 

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.

Changing dates to date format
 

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.

Changing dates to date format
 

Sure Rick and thank for your interest.
Dates look like this : 12/31/08
12/30/08
12/29/08
Etc. on the cells and on the formula bar too.

"Rick Rothstein" wrote:

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.

Changing dates to date format
 

They look like standard dates to me, although I guess they could be Text
that looks like a date. I would think your formula should work even if those
cells are formatted as Text, so I think something else is wrong. Since you
got these dates from the web, perhaps you brought along a stray invisible
character or two. If the month portion of your dates contain a leading zero
for one-digit month numbers, then try this formula and see if it works...

=TEXT(LEFT(A1,8),"ddd")

--
Rick (MVP - Excel)


"Tigerxl" wrote in message
...
Sure Rick and thank for your interest.
Dates look like this : 12/31/08
12/30/08
12/29/08
Etc. on the cells and on the formula bar too.

"Rick Rothstein" wrote:

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.

Changing dates to date format
 

DataText to columnsNextNextColumn Data FormatDateMDY and Finish.

Now try the formula.


Gord Dibben MS Excel MVP

On Thu, 2 Apr 2009 16:51:01 -0700, Tigerxl
wrote:

Sure Rick and thank for your interest.
Dates look like this : 12/31/08
12/30/08
12/29/08
Etc. on the cells and on the formula bar too.

"Rick Rothstein" wrote:

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.

Changing dates to date format
 

It sure worked.
Thank you Gord Dibben.

"Gord Dibben" wrote:

DataText to columnsNextNextColumn Data FormatDateMDY and Finish.

Now try the formula.


Gord Dibben MS Excel MVP

On Thu, 2 Apr 2009 16:51:01 -0700, Tigerxl
wrote:

Sure Rick and thank for your interest.
Dates look like this : 12/31/08
12/30/08
12/29/08
Etc. on the cells and on the formula bar too.

"Rick Rothstein" wrote:

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.