How can I change date figure into english words

Closed
skg1981 Posts 2 Registration date Friday April 19, 2013 Status Member Last seen April 19, 2013 - Apr 19, 2013 at 04:46 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - Apr 19, 2013 at 04:55 PM
Hello,
i want to change a date written in figure in excel sheet in words.
eg 6-4-2013 into Sixth april Two thousand thirteen
please help me
Related:

2 responses

Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,166
Apr 19, 2013 at 04:50 AM
Download addon MOREFUNC from https://download.cnet.com/Morefunc/3000-2077_4-10423159.html

and then use this formula
=TEXT(A1, "MMMM") & " " & NBTEXT(TEXT(A1, "d")) & ", " & NBTEXT(TEXT(A1, "YYYY"))
skg1981 Posts 2 Registration date Friday April 19, 2013 Status Member Last seen April 19, 2013
Apr 19, 2013 at 07:27 AM
I Find difficulty to download addon MOREFUNC form cnet.com
help me
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,166
Apr 19, 2013 at 04:55 PM
Why?