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).