Question: how do you convert mm/dd/yyyy to text in excel?
Answer: =TEXT(A1,"mm/dd/yyyy")
For example, to convert a text string in cell A1 to date, you use the formula =--TEXT(A1,"mm/dd/yy") and then format the cell as a date.
That was really easy, right?