Register now or log in to join your professional community.
Using Microsoft Visual Basic for Applications functions that you can use to convert a numeric value in a Microsoft Excel worksheet cell into its equivalent in English words.
To use the sample functions to change a number to written text, use one of the methods demonstrated in the following examples:
You can change32.50 into "Thirty Two Dollars and Fifty Cents" by entering the following formula into a cell:
=SpellNumber(32.50)
You can refer to other cells in the workbook. For example, enter the number32.50 into cell A1, and type the following formula into another cell:
=SpellNumber(A1)
To enter a custom function into a worksheet, you can use Paste Function in Excel2000, or you can use Insert Function in Excel2003 or later.
To use Paste Function, follow these steps:
To use Insert Function, follow these steps: