How can I change date figure into english words

Closed
skg1981 Posts 2 Registration date Friday 19 April 2013 Status Member Last seen 19 April 2013 - 19 Apr 2013 à 04:46
Ambucias Posts 47311 Registration date Monday 1 February 2010 Status Moderator Last seen 15 February 2023 - 19 Apr 2013 à 16:55
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 47311 Registration date Monday 1 February 2010 Status Moderator Last seen 15 February 2023 11,166
19 Apr 2013 à 04:50
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 19 April 2013 Status Member Last seen 19 April 2013
19 Apr 2013 à 07:27
I Find difficulty to download addon MOREFUNC form cnet.com
help me
Ambucias Posts 47311 Registration date Monday 1 February 2010 Status Moderator Last seen 15 February 2023 11,166
19 Apr 2013 à 16:55
Why?