Q. Convert the date from first format to the second format and sort in ascending order.

[Danny03]

Date (yyyymmdd.000)	Date (mm/dd/yyyy)
20070623	?
20070624	?
20070523	?
20061202	?
20070112	?
20070519	?
20080419	?
20071017	?
20051220	?

[#2]

@Danny03 

Let's say the first date is in A2.

Enter the following formula in B2:

=DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))

Fill down, then sort on column B (or on column A)

[#3]

thankyou