convert text to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top