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/