The AblebitsSpellNumber function converts numbers to words. Can add currency labels and zero cents depending on the arguments.
The AblebitsSpellNumber function syntax has the following arguments:
However, if you need any other currency, enter it as the argument in the following order:
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:
If you do not add this argument, the number will be spelled in the title case.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!