Try this:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Format as m/d/yyyy


"Greg" wrote:

I have a report that come out of our system as a general formatted cell but
the information is a European date format (i.e. 20061101 for Nov 1st). Is
there a way to get that data into a US date format for sorting and days
between function ability?

Thanks in Advance