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?
Try using the TEXT
function.
=TEXT(A1,"dd-mm-yyyy")