Spell Number In Excel Formula

Use the spellnumber function in individual cells.

Spell number in excel formula. 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. Just reference the englishnumber function in your excel spreadsheet as follows. Enter the following formula.

In the select a function list select spellnumber followed by ok. 1234 50 one thousand. The spellnumber option is able to write dollars and cents.

However it is not a formula but a macro function or to be more precise excel user defined function udf. How to use the spellnumber function. Function spellnumbertoenglish byval pnumber updateby20131113 dim dollars cents arr array thousand million billion trillion pnumber trim str pnumber xdecimal instr pnumber.

To display the given number in dollars write a number in a cell. You can find the macro mentioned as spellnumber formula. If you need a different currency you can change dollar and cent with the name of your one.

Under or select a category followed by user defined. Based on the spreadsheet above the englishnumber function will return the following. Spell out currency numbers to english words in excel.

To do this select the cell that you want and then click insert function on the formulas ribbon. You can also manually type the value like spellnumber 22 50. In laymen terms using this function will display any given number in words.