Display plus sign for positive numbers

  • Thread starter Thread starter mrgou
  • Start date Start date
M

mrgou

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
 
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?
Click to expand...

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.
Click to expand...

Yes, it works. Thanks!
 
Back
Top