how to change date format in excel from dd/mm/yyyy to text?
['=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?']