Use a custom format like:

"+"0;-0;0

Biff

"Lamb Chop" wrote in message
...
How can I change the format of the cell so that when it is positive, it
shows "+"

e.g.

15 --- +15
-3 ----- -3




Thanks