Spell Number On Excel

There is no direct function in microsoft excel to perform the above action.

Spell number on excel. However as many and many users demanded they created and published the special vba macro code on their website. To do this select the cell that you want and then click insert function on the formulas ribbon. Steps to create the spellnumber function.

To see the completed function and how it is used in the example below download the example spreadsheet. Spellnumber is an excel function which helps you convert your numbers into words. 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.

So in this way you can easily convert numbers into words in excel in pakistani or indian rupees. Under or select a category followed by user defined. In the select a function list select spellnumber followed by ok.

1234 50 one thousand. Next enter the number or cell reference that you want and then click ok. 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.

However it is not a formula but a macro function or to be more precise excel user defined function udf. Press alt f11 to open the visual basic editor. You can find the macro mentioned as spellnumber formula.

You can also manually type the value like spellnumber 22 50. Spell out currency numbers to english words in excel function spellnumbertoenglish byval pnumber updateby20131113 dim dollars cents arr array thousand million billion trillion pnumber trim str pnumber xdecimal instr pnumber. If you need a different currency you can change dollar and cent with the name of your one.