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 you...
The closest one
=TEXT(A1,"MMM")& " " & SUBSTITUTE(LOWER(TRANSLATE(BAHTTEXT(DAY(A1)),"th","en")),"baht","") & ", " & SUBSTITUTE(LOWER(TRANSLATE(BAHTTEXT(YEAR(A1)),"th","en")),"baht","")