The grey is gone
  • The grey is gone

    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?

    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
  • Ian's Excel Addin Is Free

    In order to clear up some confusion apparently doing the rounds about my addin, I would like to state quite clearly that Ian's Excel Addin is free.  Yes, that's right, 100% free. Read More
  • What is Ian's Excel Addin?

    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. Read More
  • WinQS ASCII Import Demonstration

    See this amazing video of how the WinQS ASCII Import function can save you time.  The entire WinQS Standard Library was exported from WinQS then imported into Excel and formatted in only 72 seconds! There is no trickery involved in this video, it is a real time screen capture video. Imagine how much time you can save using this import method.  Simply register as a user and then download your copy of Ian's Excel Addin right away. Read More
  • Ian's Excel Addin User Manual

    This is the online user manual for Ian's Excel Addin.  This will be a work in progress for the foreseeable future. Read More
  • 1 The grey is gone
  • 2 What's new on the menu?
  • 3 Ian's Excel Addin Is Free
  • 4 What is Ian's Excel Addin?
  • 5 WinQS ASCII Import Demonstration
  • 6 Ian's Excel Addin User Manual
  • free-gif-images 4167 1.jpg
  • Download

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.

Chuckle Box

A butt was a Medieval unit of measurement for wine.

Technically, a buttload of wine is about 475 litres or 126 gallons.

Latest Posts

More Topics »