G
Guest
The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?
decimal places? How can I set this up?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pinmaster
Use a custom format like:
0.00;-(0.00)
HTH
J
0.00;-(0.00)
HTH
J
G
Guest
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
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
G
Guest
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
[red]
if you don't want it in red as well as parenthesis.
--
Cheers
JulieD
julied_ng at hctsReMoVeThIs dot net dot au
JulieD said: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 said:The format cell does not alllow for parenthesis around negative numbers with
decimal places? How can I set this up?
J
JoAnn Paules [MVP]
Format - Cells. Category - Accounting.
G
Guest
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
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 said:Format - Cells. Category - Accounting.
--
JoAnn Paules
MVP Microsoft [Publisher]
John Nollett said:The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?
D
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.
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
JoAnn Paules said:Format - Cells. Category - Accounting.
--
JoAnn Paules
MVP Microsoft [Publisher]
John Nollett said:The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?
J
JoAnn Paules [MVP]
I can go in and tell it no symbol in front. Are you using Excel 2003?
--
JoAnn Paules
MVP Microsoft [Publisher]
--
JoAnn Paules
MVP Microsoft [Publisher]
JulieD said: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 said:Format - Cells. Category - Accounting.
--
JoAnn Paules
MVP Microsoft [Publisher]
John Nollett said:The format cell does not alllow for parenthesis around negative numbers
with
decimal places? How can I set this up?
D
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 think it's how negative numbers show up in the currency sample listbox--either
surrounded by ()'s or with leading -'s.
JoAnn Paules said:I can go in and tell it no symbol in front. Are you using Excel 2003?
--
JoAnn Paules
MVP Microsoft [Publisher]
JulieD said: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 said: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?
W
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.
#,##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.
D
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.
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.