which formula is used to convert digits to words in ms exel?

does it require any special function.................. eg: 555 to Rs. five hundred and fifty five only

Your Answer

thank you vishnu for A2A.
you can do the required operation by simply following these simple steps which are as follows : 
Click Insert Function on the Formulas ribbon.
Under Or select a category, click User Defined. In the Select, a function list, click SpellNumber, and then click OK. Enter the number or cell reference that you want, and then click OK. 

alternatively you can just write spellnumber(the reuired number) and press enter. it will get converted. for example,  spellnumber(12.5) will convert it into "twelve rupees and 5 paise" if it is the current amount.

0
Forum   Other Related Discussions
MS Excel

Didn't get the answer.
Contact people of Talent-MS Excel directly by clicking here