Module VI· Excel Setup & Best PracticesIntermediate
Question
Which custom number formats do you need in a banker model?
Answer
Useful formats include zero as dash, negatives in parentheses, one decimal for percentages and multiples, x for multiples, turns for leverage, bps for margin changes, and explicit currency / unit labels. Good formatting makes outputs readable without changing values. Avoid formatting that hides real zeros or makes negative numbers ambiguous.