Due to the binary/decimal thing, some of my financial figures come out to -0
at that level of rounding. I am using an external provider's plug-in to
calculate the figure from an external database, so I can't use the round
function to give me 0.

Is there any way of displaying -0 as 0, but other negative values as (100),
for example?

Just a thought, but could you not check if the cell value is below 0,
and if it is, multiply it by -1?

Duncs

On 12 Jul, 11:12, Tim Green
wrote:
Due to the binary/decimal thing, some of my financial figures come out to -0
at that level of rounding. I am using an external provider's plug-in to
calculate the figure from an external database, so I can't use the round
function to give me 0.

Is there any way of displaying -0 as 0, but other negative values as (100),
for example?

How a bout a format of

[<=-0.5](0);[<0]\0;0

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tim Green" wrote in message
...
Due to the binary/decimal thing, some of my financial figures come out
to -0
at that level of rounding. I am using an external provider's plug-in to
calculate the figure from an external database, so I can't use the round
function to give me 0.

Is there any way of displaying -0 as 0, but other negative values as
(100),
for example?