Display a Ratio

To have a value show as a ratio 5.0:1 you can use a custom number function.


The value in the cell is 5, but it displays as 5.0:1. This means you can still do calculations and comparisons with the value.

The format is




Find Errors

Excel has seven error messages that can be displayed when something goes wrong with a formula.

To find errors you can use the Go To Special dialog.

Press F5 then click the Special button.

Click Formulas and then uncheck Numbers, Text and Logicals. Click OK. See image below.


Now all the error cells are selected you could apply a fill colour at this stage to make then stand out.

To move between the selected cells press the Enter or Tab keys. DON’T use the arrow keys, as this will deselect the error cells.