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 47356 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 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,171
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"))
0
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
0
Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,171
Apr 19, 2013 at 04:55 PM
Why?
0