Spell Number In Excel

Click insert module and paste the following macro in the module window.

Spell number in excel. The spellnumber option is able to write dollars and cents. Spellnumber is a manually created function through vba programming to change a number to written text. You can also manually type the value like spellnumber 22 50.

In this article we will learn step by step how to create this spellnumber function using the vba function. Spellnumber is an excel function which helps you convert your numbers into words. Use the spellnumber function in individual cells 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.

There is no effective function except using a vba code to solve it in excel. Press enter to confirm the formula. If you need a different currency you can change dollar and cent with the name of your one.

You can find the macro mentioned as spellnumber formula. However it is not a formula but a macro function or to be more precise excel user defined function udf. Quickly convert or spell out a number into english words in excel in excel you may need to convert or spell out a numeric value a number into english words such as to convert 100 25 into english words one hundred dollars and twenty five cents.

The following long vba code can help you to spell out numbers to text strings. Spell out currency numbers to english words in excel. In laymen terms using this function will display any given number in words.