Use a custom format such as +#,##0;-#,##0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"bk4345" wrote in message
...
I want to show "+" or "-" in a cell but when I do, the formula doesn't
function correctly. I thought there was an action you could take, like
putting the + in (+) or something to make the formula ignore the symbol.