Convert Number to Word (SpellNumber)
A very much need function which should allow Excel users to convert number to word.
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.
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.