How do I format a negative number in parenthesis?

[John Nollett]

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

 

[pinmaster]

Use a custom format like:

0.00;-(0.00)

HTH
J

 

[JulieD]

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

 

[JulieD]

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

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

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

 

[JoAnn Paules [MVP]]

Format - Cells. Category - Accounting.

 

[JulieD]

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

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]

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

 

[Dave Peterson]

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.

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

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]

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

 

[JoAnn Paules [MVP]]

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

--

JoAnn Paules
MVP Microsoft [Publisher]

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

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]

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

 

[Dave Peterson]

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.

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

--

JoAnn Paules
MVP Microsoft [Publisher]

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

Format - Cells. Category - Accounting.

--

JoAnn Paules
MVP Microsoft [Publisher]



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

 

[wjohnson]

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.

 

[Dave Peterson]

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.

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.