Forum Discussion
Date Format where the date is spelled out in its entirety
Hello,
Is there a way to have excel format a date from numbers into a full text spelling?
e.g. 05/01/2025 input and the format converts it to May First, Two Thousand Twenty-Five
Thank you for your help.
The closest one
=TEXT(A1,"MMM")& " " & SUBSTITUTE(LOWER(TRANSLATE(BAHTTEXT(DAY(A1)),"th","en")),"baht","") & ", " & SUBSTITUTE(LOWER(TRANSLATE(BAHTTEXT(YEAR(A1)),"th","en")),"baht","")
