Converting date into words

Closed
sankar - Jul 1, 2012 at 12:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 1, 2012 at 12:34 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

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 1, 2012 at 12:34 AM
it is difficult to convert 22 to twenty two unless you use some third party addin.

but you can have 22 APR 2012. you have to format it like this

number to words e.g. 22 to twenty two

see
https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98?ui=en-us&rs=en-us&ad=us
or
morefunc
https://download.cnet.com/Morefunc/3000-2077_4-10423159.html
which contain among many other function this conversion function also
0