exceldatecell-formatting

Convert Date to Text without losing the format in Excel?

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?

Solution

  • Try using the TEXT function.

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