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:
Over the years working as a Quantity Surveyor, I discovered that Microsoft Excel, while a wonderful tool, lacked certain functions. In order to overcome these shortcomings, I developed custom procedures and functions to enhance my Excel experience and productivity. Instead of keeping these tools to myself, I have decided to share them with anyone who is interested in trying them out. Your feedback on the addin will be appreciated and will assist in the further development of this product.