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.
|