+ Reply to Thread
Results 1 to 3 of 3

VBA SpellWord

  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    Philippines
    MS-Off Ver
    Office 2013
    Posts
    2

    VBA SpellWord

    Hi,

    I'd like to seek any help. I already figured out the code needed to convert numeric value into English word in excel. However, I'd like to change the decimal figure to 20/100 instead of twenty cents. Can anyone give me a code on how to do this?

    Thank you very much in advance.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: VBA SpellWord

    Although I can not help you with your question it is usefull to add the used code on the forum.

    Please add the code between tags #
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-16-2016
    Location
    Philippines
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: VBA SpellWord

    Thanks oeldere. The code used I used is the one you can find over the internet but made some editing as to my preference. What I want to do is when the SpellWord conversion shows:

    Two Hundred Thirty Four Thousand Five Hundred Sixty Seven Pesos and Ninety Eight Cents

    I'd like it to be

    Two Hundred Thirty Four Thousand Five Hundred Sixty Seven Pesos and 98/100

    You think this is possible? I really don't know anything about creating codes.

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1