The grey is gone

Excel Tips & Tricks

Ctrl+Space selects an entire column.  (Same as clicking on column letter at the top of the screen.)

  • Excel Sparkle

    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
  • 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 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 Excel Sparkle
  • 2 The grey is gone
  • 3 What's new on the menu?
  • 4 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


  • Don't get in a stranger's car.
  • Don't meet people over the Internet.



  • Literally summon strangers from the Internet to get into their car.

Site Visitors

61%South Africa South Africa
22%United States United States
5.1%Mauritius Mauritius
2.8%Kenya Kenya
2.2%United Arab Emirates United Arab Emirates
1.2%Botswana Botswana
0.9%Swaziland Swaziland
0.6%Thailand Thailand
0.6%Namibia Namibia
0.6%Japan Japan

Yesterday: 17
This Week: 40
Last Week: 45
This Month: 186
Last Month: 298
Total: 14159

Vulnerability Scanner

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.
More information Ok