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

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

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