Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change display of positive numbers | Excel Discussion (Misc queries) | |||
how do i display a variance in all positive numbers? | Excel Worksheet Functions | |||
display plus sign on plus numbers in Excel | Excel Discussion (Misc queries) | |||
How do I display positive numbers on either side of the x-axis? | Charts and Charting in Excel | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) |