Sorry, this was not a code question, rather a worksheet formula question.
Maybe there is a more appropriate forum?

--
Donald
"Donald" wrote in message
...
I have a query extracting data from an AS400 library file, one of the
columns returns the date as "text" in the following manner mm/dd/yy

When I sort the query data by this column, the data is not sorted in the
proper date order as the data is sorted as "text". 01/01/05 is arranged
before 10/1/04 because 01 would normally precede 10.

Maybe someone can help me insert a column (H) to convert the text (column
I) to a real date that will be sorted as "dates" by normal calendar
sequence.

Here's the code I'm presently working with in column H. (query data is in
column I)
=LEFT(I3,2)&"/"&MID(I3,4,2)&"/"&MID(I3,7,2)

--
Donald