Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Show negative %'s with brackets, not "-"
0 views
Skip to first unread message
jethro
Nov 10, 1998, 3:00:00 AM11/10/98
to
Does anyone know how to format a cell to show a number that is a
negative percentage with the accounting format of brackets, not the
default "-" symbol.
We have a number that is -1.23%
We want to show it as (1.23%). Formats in Accounting section gives us
(0.0123%).
We created a custom formula and got -(1.23%) which is not right either.
negative percentage with the accounting format of brackets, not the
default "-" symbol.
We have a number that is -1.23%
We want to show it as (1.23%). Formats in Accounting section gives us
(0.0123%).
We created a custom formula and got -(1.23%) which is not right either.
Can anyone help?
Thanks
Jeff Tibben
jeff_...@parmalat.ca
Peter Beach
Nov 10, 1998, 3:00:00 AM11/10/98
to
Jeff,
Try building a custom format:
0.00%_);(0.00%)
The semi-colon splits the format of positive and negative numbers. There is
an option for a third format which would be applied to zero values (e.g.
"0.00%_);(0.00%);-").
The _) clause in the first section tells XL to leave a trailing blank equal
to the width of the ) character.
HTH
Peter
jethro wrote in message <364897...@home.somewhere>...
Ed Ferrero
Nov 11, 1998, 3:00:00 AM11/11/98
to
Hi Jethro,
0%;[Red](0)%
0 new messages