value is either a value entered manually, or a reference to a cell that contains a value

MajorCurrency is the wording applied to values before a decimal point (e.g. Rand, Dollars, etc.)

MinorCurrency is the wording applied to values after a decimal point (e.g. Cents)

Value is a required field, while MajorCurrency and MinorCurrency are optional.

The textamount function can be combined with the builtin Excel text functions, e.g. combining with the builtin upper function as =upper(textamount(123)) will result in ONE HUNDRED AND TWENTY THREE while combining with the builtin lower function as =lower(textamount(123)) will result in one hundred and twenty three.

Warning:  When files containing the textamount function are edited and saved on computers without the addin, the formula may be corrupted and display a #NAME? error in the cell when opened again.  As of version 1.0.3 of the addin, a facility has been provided which corrects the formula again.  Highlight the cell containing the formula, then select the Correct TextAmount formula option on the ribbon under Ian's Excel Addin.