Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Customising numbers

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Customising numbers

Resolved · Low Priority · Version 2003

Reply Tue 13 May 2008, 17:04Delegate Karen said...

Karen has attended:
Excel Intermediate course

Customising numbers

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

For upcoming training course dates see: Pricing & availability

Reply Thu 15 May 2008, 13:47Trainer Katie said...

RE: customising numbers

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

Excel articles

· How To Use Filtering In Excel 2010
· How We Got To The Perfect Spreadsheet: A Brief History
· Plug Into The Big Grid
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Make More of your Money with Excel 2007

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips