Results 1 to 2 of 2

Thread: DateToWord

  1. #1
    Junior Member
    Join Date
    Nov 2012
    Posts
    6
    Rep Power
    0

    DateToWord

    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

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    14
    Quote Originally Posted by lokvan View Post
    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

    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
    Last edited by DocAElstein; 06-10-2023 at 04:29 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •