Spell Number In Excel Macro

Press alt f11 to open the visual basic editor.

Spell number in excel macro. Type the formula spellnumber a1 into the cell where you want to display a written number where a1 is the cell containing the number you want to convert. In the field save as type pick the option excel macro enabled workbook. But one of our excelforum users did it.

But i had never imagined that we can convert numbers to words by just using excel formulas. Click insert module and paste the following macro in the module window. Steps to create the spellnumber function.

When you see a new dialog chose the save as option. Hold down the alt f11 keys and it opens the microsoft visual basic for applications window. Choose save as type excel macro enabled workbook.

Enter spellnumber a2 into the cell where you need to get the number written in words. And it should be like this. I had written a number of code lines to achieve this.

On the insert menu click module. The following long vba code can help you to spell out numbers to text strings. There is no direct function in microsoft excel to perform the above action.

Now you can use the function spellnumber in your excel documents. I had never imagined that we could convert numbers into words. Here a2 is the address of the cell with the number or amount.