Convert Number to Words In Excel

Ron Coderre has updated his Convert Numbers to Words sample file, to fix some international issues that a user reported recently.

The file uses a VBA function to convert a number to words, with options to specify a major currency, such as dollars and a minor currency, such as cents.


The workbook has the following features:

  • The NumsToWords() function, with parameters that allow you to change currencies and formats.
  • A sample sheet that shows how to use the function's parameters.
  • A button that will automatically export the NumToWords funtion into any open workbook. You don't have to know how to use VBA – just click the button, and the work is done for you!


You may also like...

11 Responses

  1. I prefer Laurent Longre’s NBTEXT, since it has more options, including translation to 13 languajes and captioning.

    SYNTAX :

    =NBTEXT(Number,Language,Type,Unit1 (sing),Unit1 (plur),Unit2 (sing),Unit2 (plur),Style,Gender1, Gender2)

    This function belongs to his MoreFunc add-in.

    In the other hand, I wrote a single macro wich only converts the integral part, choosing between uper or lower case. You can see it at (posted in Spanish):


  2. The.Q says:

    This is a very nice VBA, quite similar to something which I’ve used previously. I have one issue with it though, which I seem unable to fix (my VBA skills are not the best).

    I’m from Ireland, and on this side of the Atlantic, we speak numbers slightly differently than our American cousins. Whereas Americans (and probably many others) say “one hundred twenty three dollars” we would say “one hundred AND twenty three dollars (or Euro or pounds or …)”.

    Unfortunately, it’s not always as simple as having an AND after the hundred, i.e., “one hundred euro and twenty three cent”. I’ve gotten lost trying to change the VBA, and I’m sure it’s fairly simple, but I’d love to see if/how it could be done.

    Thanks in advance.

  3. Owen says:

    It works!~ Thanks a lot! I’m looking for this for months and cannot sovle it!

    Best Regards to you!

    Lu Liang from China

  4. Jim says:

    Ron’s VBA function works beautifully. Well thought out – making it easy to use. I have incorporated it into several files – saving me valuable time every week. Thanks!

  5. Deepadevi says:

    After I have created the NumberAsText in one spreadsheet, how do I enable the
    same to be used in other spreadsheet?


  6. Juliana says:

    Thank you very much, works beautifully.

  7. Dennis says:

    You made me look smart.

    I like looking smart.



  8. You’re welcome! Looking smart is a good thing. ;-)

  9. yort rosal says:

    I want to know the procedure. how can i change the dollar, to other currency.

  10. Vinayak says:

    Hi can u any one says how to convert numbers into words in Excel without macros?
    (i.e. when i am entering the 5 display Five)
    Thanks in advance..

  11. Richard Wilson says:

    Is there a way to make negative numbers show “left” and positive numbers show “right”? Thanks in advance!!!

Leave a Reply

Your email address will not be published. Required fields are marked *