With Ultimate Suite for Excel, you can easily convert numbers to words. In this quick manual, find out how to use the Spell Number utility.
Spell Number works with only one cell at a time. The result spelled number will be inserted into the cell that was selected before running the tool, so first, you need to select an empty cell for the result and then start Spell Number.
If the Utilities group is collapsed, click on it and select Spell Number in the dropdown:
In the Spell Number pane, choose your options and click the Spell button:
The function arguments are the following:
Currency
"NONE"
"USD"
"EUR"
"GBP"
"BTC"
"AUD"
"AUTO"
Letter_case
0 – "lower case"
1 – "Sentence case"
2 – "UPPER CASE"
3 – "Title Case"
Decimal_format
0 – "None"
1 – "and 10 cents"
2 – "point 10 cents"
3 – "= 10 cents"
4 – "and ten cents"
5 – "point ten cents"
As for Currency, the value that you select is automatically put into the formula. However, if you need currency that is not in the list, you can manually enter any other value into the formula in the following format:
=AblebitsSpellNumber(A1,"currency name in singular form,currency name in plural form;coin name in singular form,coin name in plural form",3,1,FALSE)
For example, if you need Hungarian forint, the formula may look like this:
=AblebitsSpellNumber(A1,"forint,forints;fillér,fillérs",3,1,FALSE)
forint and forints are for the currency name for singular and plural values; fillér and fillérs are for coins–singular and plural.
As soon as you are done with all the options, click the Spell button to get the spelled numbers inserted: