Numbers into Words

[sooshil]

Dear Excel Experts

I am a Nepalese Citizen. In my work, I need the Currency value (Sometimes only values) entered into Excel cell to be converted into Words.

Here I am using words "English Numerals" for all the numbers we type here like 1, 2, 3, and so on.

In English language, I found VBA codes to do that. I am not an Expert of Excel nor of VBA. So, I only used those codes for English Numerals.

In Nepali language, there is totally different name used for all two digit numbers. But in English numerals, there is similarity in at least 10 numerals.
For example, In English numerals, the numbers between 30 to 39 uses a common word Thirty. But in Nepali, all the numerals between 0 to 99 uses different names. So, I couldn't find any easier way to use/modify/convert any VBA code available for English to be used in Nepali for the purpose of writing number name.

Here are all the detail of Names of the Nepali Numerals in Nepali Unicode Language.

Please help me.

All the words are to be used without the quotation marks unless otherwise stated.

For Currency - "Rs." as $ we use "रू." and for
Cents we use "पैसा"
"Only" - "मात्र"
"." (period or full stop) - "।"

Numerals

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Zero[/TD]
[TD]शुन्य[/TD]
[TD]Fifty One[/TD]
[TD]एकाउन्न[/TD]
[/TR]
[TR]
[TD]One[/TD]
[TD]एक[/TD]
[TD]Fifty Two[/TD]
[TD]बाउन्न[/TD]
[/TR]
[TR]
[TD]Two[/TD]
[TD]दुई[/TD]
[TD]Fifty Three[/TD]
[TD]त्रिपन्न[/TD]
[/TR]
[TR]
[TD]Three[/TD]
[TD]तीन[/TD]
[TD]Fifty Four[/TD]
[TD]चौवन्न[/TD]
[/TR]
[TR]
[TD]Four[/TD]
[TD]चार[/TD]
[TD]Fifty Five[/TD]
[TD]पचपन्न[/TD]
[/TR]
[TR]
[TD]Five[/TD]
[TD]पाँच[/TD]
[TD]Fifty Six[/TD]
[TD]छपन्न[/TD]
[/TR]
[TR]
[TD]Six[/TD]
[TD]छ[/TD]
[TD]Fifty Seven[/TD]
[TD]सन्ताउन्न[/TD]
[/TR]
[TR]
[TD]Seven[/TD]
[TD]सात[/TD]
[TD]Fifty Eight[/TD]
[TD]अन्ठाउन्न[/TD]
[/TR]
[TR]
[TD]Eight[/TD]
[TD]आठ[/TD]
[TD]Fifty Nine[/TD]
[TD]उनान्साठ्ठी[/TD]
[/TR]
[TR]
[TD]Nine[/TD]
[TD]नौ[/TD]
[TD]Sixty[/TD]
[TD]साठ्ठी[/TD]
[/TR]
[TR]
[TD]Ten[/TD]
[TD]दश[/TD]
[TD]Sixty One[/TD]
[TD]एकसठ्ठी[/TD]
[/TR]
[TR]
[TD]Eleven[/TD]
[TD]एघार[/TD]
[TD]Sixty Two[/TD]
[TD]बैसठ्ठी[/TD]
[/TR]
[TR]
[TD]Twelve[/TD]
[TD]बाह्र[/TD]
[TD]Sixty Three[/TD]
[TD]त्रिसठ्ठी[/TD]
[/TR]
[TR]
[TD]Thirteen[/TD]
[TD]तेह्र[/TD]
[TD]Sixty Four[/TD]
[TD]चौंसठ्ठी[/TD]
[/TR]
[TR]
[TD]Fourteen[/TD]
[TD]चौध[/TD]
[TD]Sixty Five[/TD]
[TD]पैंसठ्ठी[/TD]
[/TR]
[TR]
[TD]Fifteen[/TD]
[TD]पन्ध्र[/TD]
[TD]Sixty Six[/TD]
[TD]छैसठ्ठी[/TD]
[/TR]
[TR]
[TD]Sixteen[/TD]
[TD]सोह्र[/TD]
[TD]Sixty Seven[/TD]
[TD]सड्सठ्ठी[/TD]
[/TR]
[TR]
[TD]Seventeen[/TD]
[TD]सत्र[/TD]
[TD]Sixty Eight[/TD]
[TD]अड्सठ्ठी[/TD]
[/TR]
[TR]
[TD]Eighteen[/TD]
[TD]अठार[/TD]
[TD]Sixty Nine[/TD]
[TD]उनान्सत्तरी[/TD]
[/TR]
[TR]
[TD]Nineteen[/TD]
[TD]उन्नाइस[/TD]
[TD]Seventy[/TD]
[TD]सत्तरी[/TD]
[/TR]
[TR]
[TD]Twenty[/TD]
[TD]बीस[/TD]
[TD]Seventy One[/TD]
[TD]एकहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty One[/TD]
[TD]एक्काइस[/TD]
[TD]Seventy Two[/TD]
[TD]बहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Two[/TD]
[TD]बाइस[/TD]
[TD]Seventy Three[/TD]
[TD]त्रियत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Three[/TD]
[TD]तेइस[/TD]
[TD]Seventy Four[/TD]
[TD]चौहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Four[/TD]
[TD]चौबीस[/TD]
[TD]Seventy Five[/TD]
[TD]पचहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Five[/TD]
[TD]पच्चीस[/TD]
[TD]Seventy Six[/TD]
[TD]छयत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Six[/TD]
[TD]छब्बीस[/TD]
[TD]Seventy Seven[/TD]
[TD]सतहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Seven[/TD]
[TD]सत्ताइस[/TD]
[TD]Seventy Eight[/TD]
[TD]अठहत्तर[/TD]
[/TR]
[TR]
[TD]Twenty Eight[/TD]
[TD]अठ्ठाइस[/TD]
[TD]Seventy Nine[/TD]
[TD]उनासी[/TD]
[/TR]
[TR]
[TD]Twenty Nine[/TD]
[TD]उनन्तीस[/TD]
[TD]Eighty[/TD]
[TD]असी[/TD]
[/TR]
[TR]
[TD]Thirty[/TD]
[TD]तीस[/TD]
[TD]Eighty One[/TD]
[TD]एकासी[/TD]
[/TR]
[TR]
[TD]Thirty One[/TD]
[TD]एकतीस[/TD]
[TD]Eighty Two[/TD]
[TD]बयासी[/TD]
[/TR]
[TR]
[TD]Thirty Two[/TD]
[TD]बत्तीस[/TD]
[TD]Eighty Three[/TD]
[TD]त्रियासी[/TD]
[/TR]
[TR]
[TD]Thirty Three[/TD]
[TD]तेत्तीस[/TD]
[TD]Eighty Four[/TD]
[TD]चौरासी[/TD]
[/TR]
[TR]
[TD]Thirty Four[/TD]
[TD]चौंतीस[/TD]
[TD]Eighty Five[/TD]
[TD]पचासी[/TD]
[/TR]
[TR]
[TD]Thirty Five[/TD]
[TD]पैंतीस[/TD]
[TD]Eighty Six[/TD]
[TD]छयासी[/TD]
[/TR]
[TR]
[TD]Thirty Six[/TD]
[TD]छत्तीस[/TD]
[TD]Eighty Seven[/TD]
[TD]सतासी[/TD]
[/TR]
[TR]
[TD]Thirty Seven[/TD]
[TD]सैंतीस[/TD]
[TD]Eighty Eight[/TD]
[TD]अठासी[/TD]
[/TR]
[TR]
[TD]Thirty Eight[/TD]
[TD]अड्तीस[/TD]
[TD]Eighty Nine[/TD]
[TD]उनानब्बे[/TD]
[/TR]
[TR]
[TD]Thirty Nine[/TD]
[TD]उनान्चालीस[/TD]
[TD]Ninety[/TD]
[TD]नब्बे[/TD]
[/TR]
[TR]
[TD]Forty[/TD]
[TD]चालीस[/TD]
[TD]Ninety One[/TD]
[TD]एकानब्बे[/TD]
[/TR]
[TR]
[TD]Forty One[/TD]
[TD]एकचालीस[/TD]
[TD]Ninety Two[/TD]
[TD]बयानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Two[/TD]
[TD]बयालीस[/TD]
[TD]Ninety Three[/TD]
[TD]त्रियानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Three[/TD]
[TD]त्रिचालीस[/TD]
[TD]Ninety Four[/TD]
[TD]चौरानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Four[/TD]
[TD]चौवांलीस[/TD]
[TD]Ninety Five[/TD]
[TD]पञ्चानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Five[/TD]
[TD]पैंतालीस[/TD]
[TD]Ninety Six[/TD]
[TD]छयानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Six[/TD]
[TD]छयालीस[/TD]
[TD]Ninety Seven[/TD]
[TD]सन्तानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Seven[/TD]
[TD]सड्चालीस[/TD]
[TD]Ninety Eight[/TD]
[TD]अण्ठानब्बे[/TD]
[/TR]
[TR]
[TD]Forty Eight[/TD]
[TD]अड्चालीस[/TD]
[TD]Ninety Nine[/TD]
[TD]उनान्सय[/TD]
[/TR]
[TR]
[TD]Forty Nine[/TD]
[TD]उनान्चास[/TD]
[TD]Hundred[/TD]
[TD]सय[/TD]
[/TR]
[TR]
[TD]Fifty[/TD]
[TD]पचास[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Thousand[/TD]
[TD]1000[/TD]
[TD]हजार[/TD]
[/TR]
[TR]
[TD]Lakh[/TD]
[TD]1,00,000[/TD]
[TD]लाख[/TD]
[/TR]
[TR]
[TD]Crore[/TD]
[TD]1,00,00,000[/TD]
[TD]करोड[/TD]
[/TR]
[TR]
[TD]Arab[/TD]
[TD]1,00,00,00,000[/TD]
[TD]अरब[/TD]
[/TR]
[TR]
[TD]Kharab[/TD]
[TD]1,00,00,00,00,000[/TD]
[TD]खरब[/TD]
[/TR]
[TR]
[TD]Neel[/TD]
[TD]1,00,00,00,00,00,000[/TD]
[TD]नील[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Three zeros after a two digit number is called that much thousand.
For example, 15,000 is Fifteen Thousand in English
In Nepali, 15 is written as 15 i.e. पन्ध्र and the remaining is thousand (हजार). So, combined form पन्ध्र हजार

If one more digit is there in 15,000 like 2,15,000
It will be written 2 Lakhs 15 Thousands
In Nepali दुई लाख पन्ध्र हजार

I don't think, the information I have provided here are complete. Also, I don't know, what to add more.

So, if any more information needed, I am available to give that.

Thank you very much.

 

[István Hirsch]

If I understand well, you want to convert numbers into nepali words. I am sure the suggestion below will not solve the problem, but may help to start.

I think in English converting numbers into words is solved. I have read on these pages about Rick Rothstein’s solution. Try to find this thread and convert the numbers into English words first.

Then copy the column with these numbers expressed in English words, and – after setting the two languages – paste the column in Google Translate. Check the result and if it is correct or at least can be corrected, paste the Google Translate result into your excel spreadsheet.

 

[sooshil]

If I understand well, you want to convert numbers into nepali words. I am sure the suggestion below will not solve the problem, but may help to start.

I think in English converting numbers into words is solved. I have read on these pages about Rick Rothstein’s solution. Try to find this thread and convert the numbers into English words first.

Then copy the column with these numbers expressed in English words, and – after setting the two languages – paste the column in Google Translate. Check the result and if it is correct or at least can be corrected, paste the Google Translate result into your excel spreadsheet.

Thanks István

Actually, I am not at all wanting what you have suggested.
I need the live conversion.

For example, when we get any receipt after a payment is made (or any money transaction document), then there will be a field "In words" or something like that.
That field will contain the "Total Amount" into words.
If the total amount is 4568 then that will be "Four Thousand Five Hundred Sixty Eight Dollor and zero Cent only" in English, "Rs. Four Thousand Five Hundred Sixty Eight and zero Paise only" in Nepali Version and "रू. चार हजार पाँच सय अड्सठ्ठी मात्र" in Nepali Words.

So, I need a function/VBA to convert any number from a Excel cell into Nepali Words.

Hope, I made it clear now.

 

[István Hirsch]

Thanks, I fully understand now. I thought you had an extended collection of numbers to be converted into Nepali words in a single step, where the method I suggested to try – supposing it works – would have been economical.

No doubt, to immediately convert a number entered into a cell into Nepali words in the next cell needs an other solution.

I thought of using English as a conversion language because number to words conversion in English is available, as far as I know. Then the task would be reduced to translate English text to Nepali text. It seems much harder to create a VBA from scratch which converts numbers directly into Nepali words and considers each aspect of a correct conversion.

 

[sooshil]

Thanks for your suggestion.

As I have already mentioned, the English numbering system is far more easier than Nepali.
In English, from 40 to 49, a common word Forty is used. But, in Nepali, all those numbers are named distinctly.
So, editing any VBA available for English can no more work for Nepali.

What could I do? I wish I have learnt the VBA very well. :D

Any way, If it is that much harder to start the solution or if it is the query I shouldn't ask here or anything, I beg sorry to you all.

But, working in Excel and being a Nepalese is my reality.

Thanks man.

 

[István Hirsch]

As you can see, a lot of experienced posters on these pages are eager to provide the askers with useful formulas, VBAs. There is a race, who can give the asker the best answer the fastest.
Generally.

But, I think, in the case of your question, a potential answerer should have basic knowledge of the Nepali language, beside knowing Excel, of course. Even if you know the language, this task may be a challenge: just out of curiosity, I had a look on Rick Rothstein’s solution for the (merely American!) English language solution of this task and found that the code contains more than 240 lines. I guess a Nepali version would be even longer.

Not knowing the language in this case is a great drawback. Not long ago I tried and help to separate arabic compound names; when at last I seemed to recognize a rule in the samples provided, came another ’good, but…’ request with another rule, another exception. After 3-4 such rounds, my formula would still need modifications.

I wish you to find soon someone equipped with all the necessary knowledge mentioned above.

 

[Oeldere]

Another problem that you may have is that most european / american forummembers don't have the nepalese values on their computer, so programming would be also difficult for that reason (I suppose)

 

[sooshil]

Thank you all.

As hoped by István, I too hope the same. This thread will soon find an expert able to deal with Nepali language.

I am always ready to provide any extra information required except already provided.

Thanks again.

 

[akeshav68]

Hey I have made Excel ADDINS that convert numbers into Nepali words just like you said

 

[sooshil]

Hello Keshav - akeshav68

Could you please give me that ADDINS.... I am still in a great trouble.