This article assumes that you are familiar with the VBA programming language, and with the tools that are used to create and to debug procedures. Would this be useful to you? Decimal Separator If you use acomma as your decimal separator then in the same area of code shown above, change the character used for the DecimalSeparator variable.
The SpellNumber function is now ready to use. Copy the following lines of code.
Any digits after that are changed to 0. If you want to convert numeric values to text format without displaying them as words, use the TEXT function instead. Click Save.
This limitation is also an issue if you are working with numbers in the 10's or 's of trillions. Microsoft support engineers can help explain the functionality of a particular procedure.
You can save your file as an Excel Macro-Enabled Workbook. This can be very useful if you're using Excel as a template to print checks. What you have to do is store the number as text.
Next Steps I might adapt this to work with numbers that are not currency.