Welcome to Excel Sparkle, an informal, online Microsoft Excel skills development programme. While you won't get CPD points for following these articles, you will probably be able to impress your colleagues and your boss with some of the skills that you may learn here.
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: