Do you need to easily convert your amount in figures into amount in words in your Excel spreadsheet? There’s no formula to do this, but you can use an Excel add in…
You can read about it in Microsoft Support’s How to convert a numeric value into English words in Excel
Anyway, I’ve adjusted the code a bit so that it reads in “pesos and centavos” rather than in “dollars and cents” for my friends here in the Philippines. I’ve also saved it as an Excel add-in.
Download File: spellnumber-addin
(Please right-click on the above, then leftclick on “Save Link or File As…”)
Then please remember where you saved it in hard disk.
Next, run Excel, then click on Tools – Add Ins.
Then click on the “Browse” button and look for the spellnumber-addin.xla file that you saved to your hard disk. Click on the spellnumber-addin.xla filename, then click on the OK button.
You’ll then see the Add-In window, with Spellnumber-Addin checked under the list of “Add-Ins Available” – Just click on the OK button.
And you’re ready to go!
Enter a number in cell A1, for example. Go ahead, type in 1234.56
Then, in cell A2, type in =SPELLNUMBER(A1)
Voila! Instant “amounts in words”, to help save your fingers from needless typing. 🙂
Have fun with your Excel spreadsheet!