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.
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.
