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