Display "+" when appropriate
 

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 "%"), the + sign is
conditional on the result .. and "+" is not a format..

Many thanks, Phil

Display "+" when appropriate
 

Hi

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

Andy.

"Phil C" wrote in message
...
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 "%"), the + sign is
conditional on the result .. and "+" is not a format..

Many thanks, Phil

Display "+" when appropriate
 

Andy

Briiliant! Many thanks for the prompt reply.

Phil


<Andy wrote in message ...
Hi

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

Andy.

"Phil C" wrote in message
...
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 "%"), the + sign is
conditional on the result .. and "+" is not a format..

Many thanks, Phil

Display "+" when appropriate
 

Pleasure! And thanks for the feedback.

Andy.

"Phil C" wrote in message
...
Andy

Briiliant! Many thanks for the prompt reply.

Phil


<Andy wrote in message ...
Hi

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

Andy.

"Phil C" wrote in message
...
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 "%"), the + sign is
conditional on the result .. and "+" is not a format..

Many thanks, Phil