Custom formatting

Excel gives us a bunch of standard formats for numbers. Try “Ctrl” “Shift” “5” to apply Excel’s % format to a number, or “Ctrl” “Shift” “1” to reapply Excel’s general number formatting.

But sometimes you want something other than Excel’s standard formatting. The most common example would be those (brackets) that the world of accounting seems to be so fond of for negative numbers. The (bracket) formatting isn’t one of Excel’s standard formats so you need to create a custom format to do that. “Ctrl” “1” will bring up the format cells dialog box so you can start creating custom formats – but we’ve got more detail for you in our lesson on custom formatting.

Take the Excel formulas course

Here we’ve got all the detail we think you need on Excel formulas for financial modelling: for free!