Convert date into words

Closed
sankar - Jul 1, 2012 at 03:23 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - 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,



Related:

2 responses

Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,172
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 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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