DateToWord

[lokvan]

If I want to change the Date 21/05/1962 in word Twenty first May nineteen hundred sixsty two. (Not one thousand nine hundred sixty two) and 21/05/2011 to Two thousand twelve then then how to modify this VBA code

[Rick Rothstein]

If I want to change the Date 21/05/1962 in word Twenty first May nineteen hundred sixsty two. (Not one thousand nine hundred sixty two) and 21/05/2011 to Two thousand twelve then then how to modify this VBA code
See my mini-blog article here (which is located elsewhere on this forum)...

Spell a Date out in Words (http://www.excelfox.com/forum/f22/spell-date-out-words-314/)

You can modify the last line of code to remove the word "of" and the comma if you really do not want them in your final output.




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)