B Bear Apr 9, 2010 #1 Without manually changing each entry how do I change a column of positive numbers to negative numbers. Thanks in advance Bear
Without manually changing each entry how do I change a column of positive numbers to negative numbers. Thanks in advance Bear
J Joe User Apr 9, 2010 #2 Bear said: Without manually changing each entry how do I change a column of positive numbers to negative numbers. Click to expand... Enter -1 into some cell, and copy it. Select the column or range of cells to be changed, right-click, and click Paste Special > Multiply > OK. You can now delete the -1.
Bear said: Without manually changing each entry how do I change a column of positive numbers to negative numbers. Click to expand... Enter -1 into some cell, and copy it. Select the column or range of cells to be changed, right-click, and click Paste Special > Multiply > OK. You can now delete the -1.
