Hi,

In the result of a difference, I'd like the "+" sign to be displayed
whenever the result is positive (just like the "-" sign is for negative
results).

Is there any number format that would do that?

Thanks!

Raph

On Mar 28, 10:28*am, mrgou <rgou...@gmail.com> wrote:
> In the result of a difference, I'd like the "+" sign to
> be displayed whenever the result is positive (just like
> the "-" sign is for negative results).
> Is there any number format that would do that?

Something like the Custom format "+0;-0;0" without quotes.

Change 0 to whatever precision or format you want, e.g. 0.00 for
effectively Number with 2 decimal places.

Drop that last ";0" if you want +0.

Le 28/03/2011 20:21, joeu2004 a écrit :

> Something like the Custom format "+0;-0;0" without quotes.
>
> Change 0 to whatever precision or format you want, e.g. 0.00 for
> effectively Number with 2 decimal places.
>
> Drop that last ";0" if you want +0.

Yes, it works. Thanks!