Use Data/Text to Columns. In step 3 of the wizard, indicate it's a date and
is ymd format.
Bob Umlas
Excel MVP

"Greg" wrote in message
...
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