Match Formatting

[rohitnigade]

How do I match the formatting of the below cell to be the same as the top cell?

Yellow.xlsx
	A
1	Date
2	31-07-2023 13:58:39
3	25-07-2023 12:23:24
Sheet4

 

[Joe4]

You can use the Format Painter to copy the format of one cell to another.

 

[rohitnigade]

Hi, it did not work. But I found the solution, I had to use TEXT formula whilst specifying the format and then copy-pasting it as value!

 

[Joe4]

Hi, it did not work. But I found the solution, I had to use TEXT formula whilst specifying the format and then copy-pasting it as value!

I provided the correct answer to the question that you asked.

So I am guessing that your original question doesn't accurately or fully explain what you were really after.