Date Manipulation

[Guest]

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

 

[Bob Umlas]

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

 

[Guest]

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