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