Here is what you can you expect from this post:
What is the rule to convert number into word for cardinal numbers in English System?
- Cardinal numbers refer to the size of a group. In English, these words are numerals.
0 zero (nought), 10 ten, 1 one, 11 eleven, 2 two, 12 twelve, 20 twenty, 3 three, 13 thirteen, 30 thirty, 4 four, 14 fourteen, 40 forty, 5 five, 15 fifteen, 50 fifty, 6 six, 16 sixteen, 60 sixty, 7 seven, 17 seventeen, 70 seventy, 8 eight, 18 eighteen, 80 eighty, 9 nine, 19 nineteen, 90 ninety - If a number is in the range 21 to 99, and the second digit is not zero, the number is typically written as two words separated by a hyphen.
21 twenty-one, 25 twenty-five, 32 thirty-two, 58 fifty-eight, 64 sixty-four, 79 seventy-nine, 83 eighty-three, 99 ninety-nine - In English, the hundreds are perfectly regular, except that the word hundred remains in its singular form regardless of the number preceding it.
100 one hundred, 200 two hundred, 900 nine hundred - So too are the thousands, with the number of thousands followed by the word “thousand”.
Similar fashion of the wording the numbers are followed for the Indian-Arabic number system as well.
Here is a link to the number to word converter tool that I made and the functions that it supports. Steps to Install:
Step 2: Install the Addin File
(i) Open your “Microsoft Excel”
(ii) Go to “Files:
(ii) Go to “Options”
(iv) Go to “Add-ins” tab in the new window
(v) At the bottom at “Manage” Section choose “Excel Add-ins” and click “Go”
(vi) Click “Browse” and browse and select the file downloaded from Step 1
(vii) Click “OK” and return to Excel Spreadsheet
Step 3: You can start to use the tool
Functions available
1. Word_English(insert_number_here)
Output: Number is converted into Word under the English Numbering System
2. Word_Nepali(insert_number_here)
Output: Number is converted into Word under the Nepali Numbering System
3. Word_Nepali_Unicode(insert_number_here)
Output: Number is converted into Word under the Nepali Numbering System in Unicode Text
Follow this post for more updates. You can later download more latest version of the converter tool here in the same post.
need number to word without ruppees and paisa etc.
like: 987,565.04 shall be “Nine Hundred Eighty Seven Thousand Five Hundred Sixty Five and 04/100”
Sure, Please send me your requirement at contact@sushilparajuli.com
name error aauxa kunai baata pani vayana ms2019 pro maa
Strange. It worked in MS2019 when I tested. Can you share me the error in contact@sushilparajuli.com I will try to resolve it.
Thanks for the code for Unicode characters.
if a cell is having ‘0’ then it is not converted to “Shunya”
also Unicode for zero is duplicate of 4 in ‘zen_number_to_word_spell’ function.
Also after Padma, it is not calculated in cell, i.e. only 15 character limit. while if the limit is increased, shows wrong results.
regards
Alok.
Thank you for noting the issues. I will try to cover these in my next update. Much appreciated.
OK. Thanks for your concern.
By your idea, i am adding for Bengali Words too. once your update comes, i shall share the bengali part.
Awesome, by all means. Thank you for taking interest. I can share you my source code if you want.
I am using Lenevo laptop and want to know how I convert number into word in excel kindly help.
1.
it’s better if 0.50 gave output
fifty paisas, fifty paisas, पचास पैसा
instead, it gives
No Rupees and Fifty Paisas, Rupees Fifty Paisas, रुपैयाँ पचास पैसा
2.
for #.20, #.30, …, #.90, there is an extra [space] before the [Paisas]
Thank you. I will have this resolved and update the addin file.
forgot to mention, awesome tool!
125,687,967,946.31
One Kharab Twenty Five Arab Sixty Eight Crore Seventy Nine Lakh Sixty Seven Thousand Nine Hundred Forty Six Rupees Thirty Five Paisas. it works well but it does not converts number accurately after decimal while using word_nepali command.
Thank you for identifying this bug !! I will resolve it in my next update.
Wow amazing bro
This is a very helpful tool. However the problem I’m facing is I have to install (add) the addon each time I have to use it. Once I close the PC it the addon automatically resets or something. It still shows in addon list but doesn’t work. I have to re-add it to work, any suggestions on how to make it work??
It is better to insert “Only” and “मात्र” at last of the sentences.