View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.