Converting a date from nonsense to sense

[RobertM]

How do I convert this date "060426" to "4/26/2006"

[Gary Brown]

Assuming the 060426 is in cell A1, type the following formula:-

=DATE(20&LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

Then format this cell with a format M/DD/YYYY