How to change date format in Excel? [Closed]

Report
-
Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
-
Hello,

Sir I want change date format in 25-06-2018 to 25th June 2018


How can change 25 in Th letter in upper case

Please tell me any one

2 replies

Posts
2401
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
543
Hi Manikanta,

Hope you are doing good. If A1 Contains "25-06-2018" then this formula will change the date to your desired format:

=TEXT(DATE(RIGHT(A1,4),RIGHT(LEFT(A1,5),2),LEFT(A1,2)),"dd")&"Th" & " " & TEXT(DATE(RIGHT(A1,4),RIGHT(LEFT(A1,5),2),LEFT(A1,2)),"MMMM YYYY")


Notice Th in the forrmula, you can replace it with th to suite your need.
Posts
2657
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 22, 2020
440
Hello,

May I suggest the following:
=DAY(A1) & "Th " & PROPER(TEXT(A1,"mmmm yyy"))

Best regards,
Trowa