View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ezil ezil is offline
external usenet poster
 
Posts: 43
Default convert text to date

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?