software

Hi folks

Hopefully a simple one.. How do I force excel to display a plus ( ) sign
when the result of a calculation is positive (i.e. 3.6 rather than 3.6).
The minius sign is, of course, displayed by default when the result is
negative. Probably a cell custom format setting, but can't seem to find the
right one. Unlike just adding a fixed symbol (e.g quot;%quot;), the sign is
conditional on the result .. and quot; quot; is not a format..

Many thanks, Phil

Hi

Try using a custom cell format like:
0.00;-0.00;0

Andy.

quot;Phil Cquot; gt; wrote in message
...
gt; Hi folks
gt;
gt; Hopefully a simple one.. How do I force excel to display a plus ( ) sign
gt; when the result of a calculation is positive (i.e. 3.6 rather than 3.6).
gt; The minius sign is, of course, displayed by default when the result is
gt; negative. Probably a cell custom format setting, but can't seem to find
gt; the
gt; right one. Unlike just adding a fixed symbol (e.g quot;%quot;), the sign is
gt; conditional on the result .. and quot; quot; is not a format..
gt;
gt; Many thanks, Phil
gt;
gt;
gt;
Andy

Briiliant! Many thanks for the prompt reply.

Phillt;Andygt; wrote in message ...
gt; Hi
gt;
gt; Try using a custom cell format like:
gt; 0.00;-0.00;0
gt;
gt; Andy.
gt;
gt; quot;Phil Cquot; gt; wrote in message
gt; ...
gt; gt; Hi folks
gt; gt;
gt; gt; Hopefully a simple one.. How do I force excel to display a plus ( ) sign
gt; gt; when the result of a calculation is positive (i.e. 3.6 rather than
3.6).
gt; gt; The minius sign is, of course, displayed by default when the result is
gt; gt; negative. Probably a cell custom format setting, but can't seem to find
gt; gt; the
gt; gt; right one. Unlike just adding a fixed symbol (e.g quot;%quot;), the sign is
gt; gt; conditional on the result .. and quot; quot; is not a format..
gt; gt;
gt; gt; Many thanks, Phil
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
Pleasure! And thanks for the feedback.

Andy.

quot;Phil Cquot; gt; wrote in message
...
gt; Andy
gt;
gt; Briiliant! Many thanks for the prompt reply.
gt;
gt; Phil
gt;
gt;
gt; lt;Andygt; wrote in message ...
gt;gt; Hi
gt;gt;
gt;gt; Try using a custom cell format like:
gt;gt; 0.00;-0.00;0
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;Phil Cquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi folks
gt;gt; gt;
gt;gt; gt; Hopefully a simple one.. How do I force excel to display a plus ( )
gt;gt; gt; sign
gt;gt; gt; when the result of a calculation is positive (i.e. 3.6 rather than
gt; 3.6).
gt;gt; gt; The minius sign is, of course, displayed by default when the result is
gt;gt; gt; negative. Probably a cell custom format setting, but can't seem to find
gt;gt; gt; the
gt;gt; gt; right one. Unlike just adding a fixed symbol (e.g quot;%quot;), the sign is
gt;gt; gt; conditional on the result .. and quot; quot; is not a format..
gt;gt; gt;
gt;gt; gt; Many thanks, Phil
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;