I have some text data like 26/10/2007 in a column which is extracted from web
page. I changed the format from text to date. Although it is in date format
real conversion does not takes place. When I am doing sorting operation it
sorts the data
as it is text value. How to convert the text data to date?

This will convert the text date to a date serial number:

=DATEVALUE(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,4))

Assuming that all the dates have a 4 digit year.
--
Kevin Backmann


"ezil" wrote:

I have some text data like 26/10/2007 in a column which is extracted from web
page. I changed the format from text to date. Although it is in date format
real conversion does not takes place. When I am doing sorting operation it
sorts the data
as it is text value. How to convert the text data to date?

If the text dates are all in a single column, you can:

Select the range
data|text to columns
(xl2003 menu system)
fixed width
choose date and dmy

Then finish up the wizard and give the range the date format that you like.

ezil wrote:

I have some text data like 26/10/2007 in a column which is extracted from web
page. I changed the format from text to date. Although it is in date format
real conversion does not takes place. When I am doing sorting operation it
sorts the data
as it is text value. How to convert the text data to date?

--

Dave Peterson