Amit Punia
Member
Kindly prove a formula to convert a number into text(not text to column), in words. No vba, only formula pls in indian rupees.
Formula to covert a number to Text(english word) - Only formula, no vba coding
- Thread starter Amit Punia
- Start date
Chihiro
Excel Ninja
This isn't simple. Are you opposed to add-on? If add-on is fine, see link.
http://cpap.com.br/orlando/ExcelSpellNumberMore.asp
http://cpap.com.br/orlando/ExcelSpellNumberMore.asp
Khalid NGO
Excel Ninja
Hi Amit,
VBA solution is better, if you already have one e.g. spellcurrency or spellnum etc, save the file as Excel Add-In.
Go to Excel option > Add In > Go > click brows to select the Add-In file > OK.
After that you can use the UDF in any xlsx sheet.
But if you are looking for formula based solution, see the attachment here, does not work with decimals:
http://chandoo.org/forum/threads/how-to-covert-the-amount-in-words.21633/#post-130400
Regards,
VBA solution is better, if you already have one e.g. spellcurrency or spellnum etc, save the file as Excel Add-In.
Go to Excel option > Add In > Go > click brows to select the Add-In file > OK.
After that you can use the UDF in any xlsx sheet.
But if you are looking for formula based solution, see the attachment here, does not work with decimals:
http://chandoo.org/forum/threads/how-to-covert-the-amount-in-words.21633/#post-130400
Regards,
Amit Punia
Member
Thanks a lot Chihiro & Khalid for helping me out, however I need a formula for Indian Version of Counting, (Ones/Tens/Hunderd/Thousand/Ten Thousand/Lacs/Ten Lacs/Crore/Ten Crore) instead of Millions/Billions.