## A comprehensive guide to Number Formats in Excel

Contents1 Introduction2 Structure3 Character Codes3.1 Text Characters3.2 Number Characters3.3 Date Characters3.4 Time Characters4 Conditional Number Formats5 Using Colours6 Examples6.1 Display a signature strip6.2 Prefix a number with a single character6.3 Suffix a number with a text string6.4 Pad a number with n leading zero’s6.5 Align Positive and Negative numbers6.6 Understanding…

## Excel – Pick the right tool for the job

Contents1 Tables:2 Formulas:3 Pivot Tables:4 Conclusion: Who does the caveman go to when he has a tooth ache? The dentist of course! Only back then, as you can imagine, the dentists’ tools were quite different to those used today. It has taken millennia to refine the tools we use in…

## Lookups – understanding the binary search algorithm

A comprehensive explanation of how approximate lookups work, along with practical examples and use-cases.

## Random Unique Number Generator – (VBA UDF)

RandBetweenA is an Excel worksheet function (UDF) that generate unique random numbers between a minimum and maximum number range.

## Create, Modify, Delete and Run Access Queries using Excel VBA

A handful of VBA routines to help you create, modify, delete and execute queries stored on your database (using Access for sake of example).

## ISIN Validation (M Function)

An easy-to-implement function to validate an ISIN (International Securities Identification Number), using an M function in Power Query.

## SEDOL Validation (VBA Function)

An easy-to-implement function to validate a SEDOL (Stock Exchange Daily Official List), from formula and/or VBA.

## ISIN Validation (VBA Function)

An easy-to-implement function to validate an ISIN (International Securities Identification Number), from formula and/or VBA.