How to Convert Date to Text in Excel (Explained with Examples)

how to do reverse? 26/6 is keep converting to 45103 when I try to make it a text.
I only want 26/6 in text format. better I want it like 26,6

Thank you! I was searching the web for SOO long looking for this answer!

Thank you! Very helpful!

thank ytou. Exactly what i am looking for

You're a life saver. Been looking for this formula for the longest time.

i bet, you cannot do this by using vba

Dude... The notepad saved me! I multiplied x1 once I put back into Excel and got what I needed. You just saved me hours!

Bro you have saved my life today. Great job

Thank You Very Much..

Really helpful,keep it doing 😊

Thank you for the great explanation...

Thankyou dear. God bless u

Thank you, just what I needed. It’s difficult working with dates.

Really helpful 🙏

OMGOSH you saved me tons of work, thank you!!

Thanku so much sir..😊

thanks, it was very helpful.

You are amazing and I learned a lot from you

You solved biggest problem

Needed this so badly. You saved me hours of work