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")
Faraz Shaikh
shared this idea
6 comments
-
Michael Daughety
commented
I built a custom vba function for this for numbers up to 3000 digits. It was more a fun thing to do. The hard part is identifying all the names for numbers above quadrillion and so on. A lot of assumptions were made on my part. I can't imagine trying to do this in a hundred languages.
-
A.C. WILSON
commented
Would need to be language & region specific - not easy to implement in a function. (For example, French has two different region-specific ways to spell out the numbers 70 through 79 and 90 through 99.)
-
A.C. WILSON
commented
-
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.