Question: how to change date format in excel using text?
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?