Spell Number In Excel Formula

To see the completed function and how it is used in the example below download the example spreadsheet.

Spell number in excel formula. Instead you need to create a custom function to convert the number into words yourself. In laymen terms using this function will display any given number in words. Spellnumber is an excel function which helps you convert your numbers into words.

So in this way you can easily convert numbers into words in excel in pakistani or indian rupees. 1234 50 one thousand. However it is not a formula but a macro function or to be more precise excel user defined function udf.

To do this select the cell that you want and then click insert function on the formulas ribbon. Keep the cursor in the box where you want to convert numbers into words in excel sheet and type spellnumber the cell number i e in the above if i want to convert f6 cell into words i will type spellnumber f6 and then enter. Next enter the number or cell reference that you want and then click ok.

If you need a different currency you can change dollar and cent with the name of your one. How to use the spellnumber function. Use the spellnumber function in individual cells.

You can find the macro mentioned as spellnumber formula. To display the given number in dollars write a number in a cell. The spellnumber option is able to write dollars and cents.

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. Spell out currency numbers to english words in excel. In the select a function list select spellnumber followed by ok.