Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating

Formating

ResolvedVersion 2003

Thu 16 Jul 2009, 16:35 Delegate Angella said...

Angella has attended:
Excel Introduction course
Excel Intermediate course

Formating

How do get bracket around negative numbers

Fri 17 Jul 2009, 17:55 Trainer Andrew said...

RE: Formating

HI Angella
You can right click on a cell and choose Format cells and from the category list choose custom. In the Type box try the following 0;(0) Now positive numbers will be shown as normal but negative values will be shown in brackets.

I hope this helps.

Kind regards,
Andrew

Fri 24 Jul 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips

Formating

Formating

RE: Formating

Excel articles

Excel tip:

Change the Default Width of All Columns in Excel 2010