Convert text string to date

How do you convert a text string, "112905" to a date of 11/29/05?

So it has the appropriate serial value 38685 for 11/29/05.

Thanks in advance

Try this:

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

--
Regards,
Dave


"AK" wrote:

> How do you convert a text string, "112905" to a date of 11/29/05?
>
> So it has the appropriate serial value 38685 for 11/29/05.
>
> Thanks in advance