Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
numbers in words indian number system
Hi
I am a new member and have joined the forum on the new year day. In th first place I wish all the group memeber a very happy new year. Can any one provide a vba code to convert numbers into words in india number system. i would give an example for this Rs 10,00,000 this is read as ten lakhs. the logic in indian numbering system is that the position of comma i first after three numbers from units place and for the next position i is after two numbers. Unlike in English system the position of comma i always after three numbers. hope i shall be addressed thanks gssreeniva -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
numbers in words indian number system
Happy New Year to you a;so (sorry, I couldn't work out your name from your
signature). What you ask is best handled as a custom display format. Niek Otten posted this solution a while back FormatCellsNumberCustom In the Type box, enter: ###\,##\,### -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "gssreenivas" wrote in message ... Hi I am a new member and have joined the forum on the new year day. In the first place I wish all the group memeber a very happy new year. Can any one provide a vba code to convert numbers into words in indian number system. i would give an example for this Rs 10,00,000 this is read as ten lakhs. the logic in indian numbering system is that the position of comma is first after three numbers from units place and for the next position it is after two numbers. Unlike in English system the position of comma is always after three numbers. hope i shall be addressed thanks gssreenivas --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
numbers in words indian number system
I don't recall seeing anyone post code that does this, but these references
provide code to do it in english. Perhaps it would provide a good start for you to convert it to the indian number system: http://support.microsoft.com/?id=140704 XL: How to Convert a Numeric Value into English Words http://support.microsoft.com/?id=95640 ACC: How to Convert Currency or Numbers into English Words -- Regards, Tom Ogilvy gssreenivas wrote in message ... Hi I am a new member and have joined the forum on the new year day. In the first place I wish all the group memeber a very happy new year. Can any one provide a vba code to convert numbers into words in indian number system. i would give an example for this Rs 10,00,000 this is read as ten lakhs. the logic in indian numbering system is that the position of comma is first after three numbers from units place and for the next position it is after two numbers. Unlike in English system the position of comma is always after three numbers. hope i shall be addressed thanks gssreenivas --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
numbers in words indian number system
The following addresses the placement of the comma not numbers
into words: If you have Excel 2002 or later look up bhattext in help. Otherwise the following format might help you [=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00 (This format separates groups for India/Thailand, format valid for positive numbers up to 99,99,99,999.99 or 999,999,999.99) in Excel XP see function BhatText as in Thai Bhat currency. =BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] == an alternative may be to use Control Panel, Regional Settings, Numbers, digit grouping. The above can be found on my formula.htm page, the hidden links in the above text from that page include http://office.microsoft.com/assistan...l/Bahttext.htm http://google.com/groups?selm=OwOZ4V...%40tkmsftngp02 http://google.com/groups?threadm=3B8...l fitness.com I don't recall seeing any postings for numbers to words for Indian currency but you should search the newsgroup archives. Excel Newsgroups & Searching Newsgroups Search Newsgroups using Google "Usenet Advanced Search", look at the MS Knowledge Database, other tips. http://www.mvps.org/dmcritchie/excel/xlnews.htm FWIW (For What It's Worth), I only found one of my postings for Google Search: lakhs numbers words group:*Excel* also did the same search in the MS Knowledge Base but you could modify some code that you can find in links at Strings and Manipulations http://www.mvps.org/dmcritchie/excel/strings.htm under the topic: Numbers to words (as in check protection wording) If you program what you want based on the above then you might post your completed macro to this thread so that others benefit from your coding. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "gssreenivas" wrote in message ... Hi I am a new member and have joined the forum on the new year day. In the first place I wish all the group memeber a very happy new year. Can any one provide a vba code to convert numbers into words in indian number system. i would give an example for this Rs 10,00,000 this is read as ten lakhs. the logic in indian numbering system is that the position of comma is first after three numbers from units place and for the next position it is after two numbers. Unlike in English system the position of comma is always after three numbers. hope i shall be addressed thanks gssreenivas --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change to the Indian Number System? | Excel Discussion (Misc queries) | |||
"Convert Currency to Words in Indian Style" | Excel Worksheet Functions | |||
Convert number to words with formula for Indian System. | Excel Worksheet Functions | |||
Change amount into english words according to Indian format | Excel Discussion (Misc queries) | |||
How to format a cell to represent Indian Currency System? | Excel Discussion (Misc queries) |