Hints and tips home » Excel hints and tips » Bracketed negative numbers

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

Added by Orok on 27th September 2006

More Excel hints and tips, like:

• paste functions box quickly
• Reset Excel toolbars to default settings
• Get back to active cell