View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AK
 
Posts: n/a
Default 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