How do I invert (change) the sign in a column of numbers?
G Gord Dibben Oct 1, 2007 #2 You want negatives to become positives and positives to become negatives? Enter -1 in an empty cell. Copy that and select the column then Edit>Paste Special(in place)>Multiply>OK>Esc. Gord Dibben MS Excel MVP
You want negatives to become positives and positives to become negatives? Enter -1 in an empty cell. Copy that and select the column then Edit>Paste Special(in place)>Multiply>OK>Esc. Gord Dibben MS Excel MVP
J JE McGimpsey Oct 1, 2007 #3 One way: Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons.
One way: Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons.
G Guest Oct 1, 2007 #4 Thank you. It works. Gord Dibben said: You want negatives to become positives and positives to become negatives? Enter -1 in an empty cell. Copy that and select the column then Edit>Paste Special(in place)>Multiply>OK>Esc. Gord Dibben MS Excel MVP Click to expand...
Thank you. It works. Gord Dibben said: You want negatives to become positives and positives to become negatives? Enter -1 in an empty cell. Copy that and select the column then Edit>Paste Special(in place)>Multiply>OK>Esc. Gord Dibben MS Excel MVP Click to expand...
G Guest Oct 1, 2007 #5 Thank you. It works. JE McGimpsey said: One way: Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click to expand...
Thank you. It works. JE McGimpsey said: One way: Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click to expand...