Convert date into words

Closed
sankar - Jul 1, 2012 at 03:23 AM
aquarelle Posts 7118 Registration date Saturday April 7, 2007 Status Moderator Last seen July 29, 2022 - Jul 2, 2012 at 10:58 AM
Hello
i want to know how to convert date into words(english) in excel 2003 or 2007
for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Two April Two Thousand Ten.
Thanks,



2 replies

Ambucias Posts 47360 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,255
Jul 1, 2012 at 04:32 AM
Hello

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"))

Regards
0
aquarelle Posts 7118 Registration date Saturday April 7, 2007 Status Moderator Last seen July 29, 2022 491
Jul 2, 2012 at 10:58 AM
Hi,

Please, do not post more than one discussion for the same problem.
I close this one.

Thanks to continue on your first created discussion : https://ccm.net/forum/affich-658978-converting-date-into-words

Regards
0