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!