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!