How do I format cells to show negatives in brackets?

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
At present my spreadsheet shows any negatives in the following manner:

-50

I would like to show these neagtives as follows:

(50)

How do I change this?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
There are some preset options in the Number category of the Format Cells dialogue (Number tab).

You can choose bracketed or bracketed and red, etc.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,363
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top