Convert Date to Text without losing the format in Excel

Question

I have a column in Excel Sheet which contains all the dates in custom dd-mm-yyyy format. I need to convert all these dates to text without losing the format. If I am changing the cell format to Text, I am losing the format. I tried to copy the cell values as values but did not work. I searched a lot on the internet, but did not find any useful resource. What's the possible solution?

Answer 1

The steps are as follows:
Copy the dates that are in the cells that you want to convert.
Copy the text and paste it into Notepad.
Return to Excel and pick the cells into which you wish to paste the dates.
Go to Home –> Number and pick the Text format with the cells chosen (from the drop down).