How to convert date to general in excel without losing format

0 votes
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?
Mar 30, 2022 in Database by Edureka
• 13,690 points
• 55,768 views

1 answer to this question.

0 votes

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

Convert Date to Text in Excel - Explained with Examples

answered Apr 1, 2022 by gaurav
• 25,250 points

Related Questions In Database