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?
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?
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?
Sub changepos()
For Each c In Range("c1:c2")
c.Value = -c
Next c
End Sub
--
Don Guillett
SalesAid Software
[email protected]
"Kelly" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks