PC Review


Reply
Thread Tools Rate Thread

Display plus sign for positive numbers

 
 
mrgou
Guest
Posts: n/a
 
      28th Mar 2011
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
 
Reply With Quote
 
 
 
 
joeu2004
Guest
Posts: n/a
 
      28th Mar 2011
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.
 
Reply With Quote
 
mrgou
Guest
Posts: n/a
 
      29th Mar 2011
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!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plus Sign For Positive Numbers charles.kendricks@charter.net Microsoft Access 1 11th Jun 2006 12:29 PM
positive numbers with '+' sign =?Utf-8?B?YWxla20=?= Microsoft Excel Misc 2 18th Jun 2004 10:14 AM
How to display the plus sign for positive numbers. Tony Zannini Microsoft Excel Worksheet Functions 2 27th Feb 2004 04:38 PM
Showing plus sign on positive numbers =?Utf-8?B?VGhlIFJlZGhlYWQ=?= Microsoft Excel Programming 2 4th Feb 2004 01:31 PM
Displaying a + sign on positive numbers Alex Microsoft Excel Discussion 3 11th Nov 2003 12:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:46 PM.