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?
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?
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?
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?
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?
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?
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.