Thread: Convert text string to date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default Convert text string to date
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
Reply With QuoteReply With Quote