Simple question

Bkelley

New Member
Joined
Jan 26, 2005
Messages
11
How do I make it so that the format of negative numbers is (100.00) rather than - 100.00?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

mzspazchick

New Member
Joined
Nov 10, 2005
Messages
39
Hi,
You click on Format Cells, then Number or Currency, depending on which you prefer, then it will display four choices, pick which you would like, click OK and your set.
Michelle
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,759
Office Version
  1. 365
Platform
  1. Windows
Hi B

You'll have to use a custom format for this. If you refer to Excel help and search for "Create a custom format", you'll see that you can customise a format, using four sections, separated by semicolons.
The first section deals with postive numbers, the second for negative (this is the one you want to edit) etc etc.

So, if you select one of the built-in custom formats similar to this one:

_-* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_-

.....you can edit it so that the second section contains your brackets, to something like this:

_-* #,##0.00_-;(-* #,##0.00_-);_-* "-"??_-;_-@_-


........ but use the Excel help for the exact meanings of the various formats.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,231
Messages
5,571,028
Members
412,355
Latest member
BasicExelHelp
Top