Date Conversion

[Terry]

How do I convert a data string date when it imports as yymmdd to full date
description.

example
100115 need to convert to Jan 15, 2010
91210 need to convert to Dec 10,2009

 

[Bob Phillips]

Try

=DATE(2000+LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2),RIGHT(A1,2))