amount_in_words

Use the amount_in_words function to convert a number into a notation representing an amount of currency, written out fully in words. The output is localized based on the current output language.

amount_in_words ( input )

This function returns a value of type TEXT.

The function has one parameter:

• input, type NUMBER. The amount to be converted. This function supports amounts for all output languages up to 1000 billion (exclusive). Results for values outside this range are undefined.

The input value is rounded to cents.

Currencies are represented by the pre-Euro currencies. Use the amount_in_words_euro function to produce an amount in the Euro currency, or the euro function to switch the currency representation. See amount_in_words_euro and euro, respectively.

Examples

amount_in_words (0.12) results in "zero pounds and twelve pence"

amount_in_words (-0.12) results in "zero pounds and twelve pence negative"

amount_in_words (1234567.89) results in "one million two hundred and thirty-four thousand five hundred and sixty-seven pounds and eighty-nine pence"

amount_in_words (1234567.89) results in "een miljoen tweehonderdvierendertigduizend vijfhonderdzevenenzestig gulden en negenentachtig cent" (output language NLD)

amount_in_words (12.344) results in "twelve pounds and thirty-four pence"

amount_in_words (12.345) results in "twelve pounds and thirty-five pence"