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
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
- 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

2 replies

Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,291
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
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,291
Apr 19, 2013 at 04:55 PM
Why?
0