Customising numbers

The UK's most regular instructor-led training courses.
Training information: excel-training-course · Microsoft excel training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Customising numbers

Karen has attended:
Excel Intermediate course

by - delegate Karen [1 post] (2008 May 13 Tue, 17:04) Reply

How do you create a customised number that shows a number as a percentage and if negative appears in red.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: customising numbers

by - trainer Katie gold contributer [214 posts] (2008 May 15 Thu, 13:47) Reply

Hi Karen,

Thank you for your question.

For formatting a number to show both percentages as well as red negatives, you need to choose CUSTOM under format.

1. On your number, choose FORMAT CELLS > NUMBER tab > CUSTOM option (last item on the list)
2. In the box on the right hand side, type in (or just copy & paste) the following syntax: 0.00%;[Red]-0.00%
3. press OK

Hope this helps.

Kind regards,

Katie Woo
Microsoft Certified Trainer