Currency to wore

[atuljadhav]

how to convert indian currency in word
like

5,00,000 = five lack only
10,00,000 = Ten lack only

pl give me that formula

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=574339

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).