C
Cheek
How do I invert (change) the sign in a column of numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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
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
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.
Enter -1 in an empty cell. Copy the cell. Select your column. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
C
Cheek
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
C
Cheek
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.