textamount Function Featured

  • Bookmark and Share

This function is used to convert a numerical value into its equivalent textual representation, e.g. 123 becomes One Hundred and Twenty Three.  Used in the format of =textamount(value[,"MajorCurrency"][,"MinorCurrency"]) where:

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.

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.