Question: how to change date format in excel using text function?
Answer: Select the cells that have dates that you want to convert and copy it.
Open a Notepad and paste it there. ... 
Now switch back to the Excel and select the cells where you want to paste these dates.
With the cells selected, go to Home –> Number and select the Text format (from the drop down).