Change the sign on all numbers in a spread sheet
 

I have a spread sheet that I need to change all of the negative numbers to
positve and positive to negative. Is there an easy way to do this, other
than redoing each cell or adding a column to multiply by -1?

Change the sign on all numbers in a spread sheet
 

Put -1 in a "spare" cell and copy (this cell).
Select data to changed
Edit==Paste Special== Operation==Multiply
Delete -1 from your "spare" cell

(Backup before attempting above!)

HTH

"Kelly" wrote:

I have a spread sheet that I need to change all of the negative numbers to
positve and positive to negative. Is there an easy way to do this, other
than redoing each cell or adding a column to multiply by -1?

Change the sign on all numbers in a spread sheet
 

Sub changepos()
For Each c In Range("c1:c2")
c.Value = -c
Next c
End Sub

--
Don Guillett
SalesAid Software

"Kelly" wrote in message
...
I have a spread sheet that I need to change all of the negative numbers to
positve and positive to negative. Is there an easy way to do this, other
than redoing each cell or adding a column to multiply by -1?