Spell Number In Excel Pesos

Convert currency numbers to english words.

Spell number in excel pesos. Spell out currency numbers to words with long vba. 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.

In excel you cannot quickly convert numbers to english words except vba. If you are looking for the number to text conversion which means you want excel to see your number as text it s a bit different thing usually you simply need to change the cell format in excel select your range with numbers press ctrl 1 on the number tab and select text in the category field. Spellnumber is an excel function which helps you convert your numbers into words.

Copy paste code from this link https goo gl 6wthrn. 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. Please find the details in the article ways to.

Press alt f11 keys to open the microsoft visual basic for application window. In laymen terms using this function will display any given number in 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.

The code is for converting numbers to words not for currency conversion it will not display 10 crore for example. 1234 50 one thousand. So in this way you can easily convert numbers into words in excel in pakistani or indian rupees.

Whatever numbers you send to function they will be converted as is so i suggest making the conversions before ending the number to the function. Click insert module and paste below vba to the new module window.