How do I format a negative number in parenthesis?
 

The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

Use a custom format like:

0.00;-(0.00)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498565

How do I format a negative number in parenthesis?
 

Hi John

click on the cell
choose format / cell
under CUSTOM
type
#,##0.00;[Red](#,##0.00)

this should give you what you want.

--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"John Nollett" wrote:

The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

oops should have said remove the
[red]
if you don't want it in red as well as parenthesis.
--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"JulieD" wrote:

Hi John

click on the cell
choose format / cell
under CUSTOM
type
#,##0.00;[Red](#,##0.00)

this should give you what you want.

--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"John Nollett" wrote:

The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



"John Nollett" <John wrote in message
...
The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

Hi JoAnn

not on my system (comes up with a - sign in front of the $ sign), i'm
guessing it probably has something to do with regional settings.


--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"JoAnn Paules [MVP]" wrote:

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



"John Nollett" <John wrote in message
...
The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

I think so, too.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

JulieD wrote:

Hi JoAnn

not on my system (comes up with a - sign in front of the $ sign), i'm
guessing it probably has something to do with regional settings.

--
Cheers
JulieD

julied_ng at hctsReMoVeThIs dot net dot au

"JoAnn Paules [MVP]" wrote:

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



"John Nollett" <John wrote in message
...
The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?




--

Dave Peterson

How do I format a negative number in parenthesis?
 

I can go in and tell it no symbol in front. Are you using Excel 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]



"JulieD" wrote in message
...
Hi JoAnn

not on my system (comes up with a - sign in front of the $ sign), i'm
guessing it probably has something to do with regional settings.


--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"JoAnn Paules [MVP]" wrote:

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



"John Nollett" <John wrote in message
...
The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?

How do I format a negative number in parenthesis?
 

I didn't think that it's the currency symbol.

I think it's how negative numbers show up in the currency sample listbox--either
surrounded by ()'s or with leading -'s.



"JoAnn Paules [MVP]" wrote:

I can go in and tell it no symbol in front. Are you using Excel 2003?

--

JoAnn Paules
MVP Microsoft [Publisher]

"JulieD" wrote in message
...
Hi JoAnn

not on my system (comes up with a - sign in front of the $ sign), i'm
guessing it probably has something to do with regional settings.


--
Cheers
JulieD


julied_ng at hctsReMoVeThIs dot net dot au


"JoAnn Paules [MVP]" wrote:

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



"John Nollett" <John wrote in message
...
The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?




--

Dave Peterson

How do I format a negative number in parenthesis?
 

Copy and paste this in the FORMAT CELL in the CUSTOM BOX:
#,##0_);[Red]-(#,##0.00), this was the results only in "RED"
-(5,678.00)
Just remove the [RED] if you do not want the number in red.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498565

How do I format a negative number in parenthesis?
 

Yep. A custom format will work.

But I think the question evolved into why the parentheses don't show up in the
Negative number list box under the currency category of Format|Cells|Number tab.

wjohnson wrote:

Copy and paste this in the FORMAT CELL in the CUSTOM BOX:
#,##0_);[Red]-(#,##0.00), this was the results only in "RED"
-(5,678.00)
Just remove the [RED] if you do not want the number in red.

--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498565

--

Dave Peterson