N/a

Resolved · Low Priority · Version 2010

Fri 10 Nov 2017, 16:11 Delegate Olivia said...

Olivia has attended:
Excel Intermediate course
Excel Advanced course

N/a

n/a

Mon 13 Nov 2017, 09:53 Trainer Wendy said...

RE: n/a

Thanks Olivia

Please feel free to post any questions you may have in future

Kind regards

Wendy

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

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.

View all Excel hints and tips