Converting date into words

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