Interesting Custom Format Problem

[mr-tom]

Hi,

I've been asked to display positives in percentages.

I.e, previously a list might have run:
25%
-30%
0%

I've created the following custom format: +0%;-0% This creates the
following list:
+25%
-30%
+0%

Set aside for a minute why anybody would wish to do this - I've learned not
to ask that question any more...

The problem I have is this - the 0% is displayed as +0% which just isn't
right.

I've entered a zero in the cell so that I know I'm not looking at 0.00000001
rounded to +0% and it makes no difference.

So my custom format of +0%;-0% gets excel to do one thing for negatives and
something else for all other numbers (positives and zero).

Is there a way to get it to do something different again for true zeros or
ideally for stuff that displays as (i.e. rounded to) zero?

Thanks in advance!

mr-tom.

 

[Jacob Skaria]

Try

+0%;-0%;0

If this post helps click Yes

 

[eksh]

custom format like this
+0%;-0%;0%