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 » Data formatting

	98.1 % recommend us
	More live stats...

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

Training information:

Data formatting

Resolved · Low Priority · Version 2003

Reply Fri 20 Mar 2009, 16:58Delegate Terry said...

Terry has attended:
Excel Intermediate course

Data formatting

How do you enter brackets to show a minus figure and make the coulour red when a negative figure is entered

For upcoming training course dates see: Pricing & availability

Reply Tue 24 Mar 2009, 10:18Trainer Stephen said...

RE: Data formatting

Hi Terry

Thank you for your question

First select the cells to format and then click on format-cells and click on the number tab. Next select the custom option from the category list and type the following into the type text box on the right hand side of the dialog

#,##0;[Red](#,##0)

The element before the semi colon shows the format if the number is positive and after when it is negative. Note the word red in square brackets and the brackets around the number format showing that the negative number is red and in brackets

Regards

Stephen

Mon 30 Mar 2009: Automatically marked as resolved.

Excel articles

· Edit Anywhere With Mobile Spreadsheets
· From the Classroom to the Corporate World
· Learn How To Chart Your Deeper Data
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Using Excel For Simple Home Accounting And Budgets

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

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips