Giday UK.

'A' contains a month & year, ie: Nov 2001

'B' contains a random value, ie: 320,000 (Three hundred & twenty thousand,)


Last year, we created a spreadsheet tp keep track of various data for our clients, consisting of a workbook for each client containing the sheets:


I am trying to create a list box in Excel 2007.  I can draw one successfully, but when I right-click and select "Format Control", I do not have the dialog box "Control" available - so I can't speci


If I enter a number beginning with 0 such as 01234 unless I put a ' in front it drops the 0 when I press enter. Is there a way of stopping it doing this other than entering a ' each time?


I have a home-grown spreadsheet along the old inland revenue "form 930" lines, which records the taxpayer's total SA liability and breakdown for each year, linked to another worksheet within the wo


U-turn if you want to customise the ribbon


Courtesy of The Daily Dose of Excel blog (and a helpful tweet from @

A client of has asked me a question I cannot answer.  He asked me to come up with a formula that calculates this problem:


In honour of Oscar season, Debra Dalgleish posted an updated version of her Excel movie database on her