-
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. Read More
-
To paraphrase Johnny Nash, "I can see clearly now the grey is gone." The grey in question being the mysterious greyed out ribbon even when a workbook is open in Excel. Read More
-
What's new on the menu? Quite a bit actually, with the new Excel ribbon based interface for a start. The old menu driven interface for the addin has been replaced with the user friendly Office style ribbon interface. The new ribbon interface for Ian's Excel Addin Read More
-
This is the online user manual for Ian's Excel Addin. This will be a work in progress for the foreseeable future. Read More
A spate of Excel crashes in the office was recently brought to my attention. While not all of the crashes were attributed to the use of my addin, it did seem as though the chances of crashing were increased when my addin was present. This seemed to be related to the way the addin was loading; a typical Excel addin is loaded as a fully fledged addin (see this article for more on Excel addins) while I was using a more user friendly option, the XLSTARTUP folder.
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:
This is the online user manual for Ian's Excel Addin. This will be a work in progress for the foreseeable future.
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.
Latest Posts
-
-
- Formatted ASCI import
- In Ian's Excel Addin / General Comments & Suggestions
- 24 Feb 2021 17:18
-
-
-
- File appears not to be valid WinQS ASCII file
- In Ian's Excel Addin / Installing & Upgrading
- 14 Dec 2020 08:38
-
-
-
- Installing add-in on Office 365 Excel
- In Ian's Excel Addin / Installing & Upgrading
- 27 Oct 2020 12:18
-
-
-
- Excel file doesn't import
- In Ian's Excel Addin / Bug Reports
- 11 Aug 2020 10:50
-