Display plus sign for positive numbers
 

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

Display plus sign for positive numbers
 

On Mar 28, 10:28*am, mrgou 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.

Display plus sign for positive numbers
 

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!