Excel question
Does anybody know how you can make a positive number become a negative number
when copied into a different cell in Excel? Thank you |
Excel question
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: Does anybody know how you can make a positive number become a negative number when copied into a different cell in Excel? Thank you |
Excel question
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. Clare wrote: Does anybody know how you can make a positive number become a negative number when copied into a different cell in Excel? Thank you |
All times are GMT +1. The time now is 12:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com