I believe there is a way that you can change values on screen that are
positive to negative or vice versa!!

I would be really grateful if someone could tell me how??!!!


to change A1 in another cell use the formula =A1*-1 or use a macro, I have
not checked this but it should work ok.

Sub PosToNeg()
dim c

For each c in selection
If isnumeric(c) then
c.value = c*-1
end if
next

End Sub

Peter