Convert Date to Text without losing the format in Excel?

Ali Sheikh picture Ali Sheikh · Sep 6, 2017 · Viewed 8.1k times · Source

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

David Lee picture David Lee · Sep 6, 2017

Try using the TEXT function.

=TEXT(A1,"dd-mm-yyyy")