I answered a similar question to this a few weeks back. Check out if this
helps, but as I recall, the OP didn't answer my last question
http://tinyurl.com/4m4sp

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SVC" wrote in message
...
The faq is useful for the american style but i need the indian style which
is detailed below. please help at the earliest in the group or direct to
my
mail id which is

Currency symbol = Rs.
Currency names = Rupees(as Dollors) & Paise(as Cents)
denomations = units, tens, hundreds, thousands, ten thousands, lakhs, ten
lakhs, crorers, ten crorers
the digit sepration from the left to right is in 3 by 2 by 2 by 2
formation.

eg: Rs. 12,34,56,789.11 is called as twelve crores thirty four lakhs fifty
six thousand seven hundered and eleven paise


"Bob Phillips" wrote in message
...
See

http://www.xldynamic.com/source/xld.xlFAQ0004.html
Convert Numbers To Text

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SVC" wrote in message
...
I want to convert the amount entered in excel sheet to their respective
text
value.
eg: 1,24,525
to be converted as
one lakh twenty four thousand five hundered and twenty five.