Convert Number to Word (SpellNumber)
A very much need function which should allow Excel users to convert number to word.
Example :
1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.
Note : the conversion should be based on regional setting and user should be able define the currency code.
=SpellNumber([cellReference],"CurrencyCode")

3 comments
-
Stefanie Gatti commented
Please add the SpellNumber function as a built in function in Excel. It is cumbersome to have to use VBA. The function would be very useful.
-
Chandra Sekhar Bale commented
Please add this to excel as built in function. This will help a lot, and will be a great and minimum required feature for and application like excel. Hope you will consider this request. Thank you.
-
Oz du Soleil commented
I've had clients who've wanted this for years. It would be nice to have this as a built-in feature rather rather than having to dig around in VBA.