Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |