Excel question

C

Clare

Does anybody know how you can make a positive number become a negative number
when copied into a different cell in Excel?

Thank you
 
S

Stefi

It depends on how do you copy!
If you want to have a standard column (say column B) containing a negative
copy of another column (say column A) then enter formula =-A1 in B1.

If you manually copy and paste separate cells into other cells then you need
a change event procedure but first you have to specify the target cells you
want to apply the procedure to (e.g. if target cell is in column B):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then 'column B
Target.Value = -Target.Value
End If
End Sub

Regards,
Stefi

„Clare†ezt írta:
 
L

Lori

Try entering -1 in the cell to copy to first. Then copy the cell,
select the cell to copy to and choose edit-paste special with multiply
selected.
 
Top