Ian's Excel Add-in Ribbon Menu

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 add-in, 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

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.