Spell Number In Excel Is Not Working

I m using excel 2007 in windows 8 i ve created a vba module with following code and saved the file as xlsm.

Spell number in excel is not working. A vb project dialog box opens. You can save your file as an excel macro enabled workbook xlsm to keep your file in its current format. How to convert number to words in excel 2.

29 95 as twenty nine dollars and ninety nine cents pounds and pence for gbp euros and eurocents for eur etc. So what you need is not just convert numbers to words in excel е g. Spell out currency numbers to english words in excel.

1 hold down the alt f11 keys and it opens the microsoft visual basic for applications window. If you click file save. Excel cannot save a workbook with macro functions in the standard macro free workbook format xlsx.

In other words it converts a numeric value into english words with currency. In this article we will learn step by step how to create this spellnumber function using the vba function. 2 click insert module and paste the following macro in the module window.

123 45 to one hundred and twenty three forty five but spell out dollars and cents е g. The following long vba code can help you to spell out numbers to text strings. Theworldofinformation spellnumberinexcel spellnumberinindianrupees spellnumber1.

Spellnumber is a manually created function through vba programming to change a number to written text.