Converting numbers into words in Excel
- 1 minWhat?
A quick blog that contains the script needed for converting numbers into words in your excel sheet
TL;DR
* Open Excel, press Alt+F11
* Go to insert-> Module and paste the script (For USD - get it from the official doc linked below; For INR - use the script shown below)
* Alt+Q, and now you have a function named =SpellNumber(A1) which will convert the number in A1 into wordsSteps
Follow the official guide from microsoft office support to get it working for USD
To get it working for ₹₹₹ instead of $$$, use this script that I found floating on the internet:
Credits to the original dev, I just changed it a little for my convenience.
That’s all folks!
Related Posts
