What is the step by step process to change an entire column of numbers from positive numbers to negative numbers and vise versa? Not one number at time.
2006-10-14 08:24:43 · 4 answers · asked by kim1084 1 in Computers & Internet ➔ Other - Computers
-Type -1 in a cell off to the side
-Select that cell and copy
-Right-click on the column header of the column that you wish to change
-Choose Paste Special... | Multiply
-Click OK
You are done. The values in the column will be changed without any other copying or pasting.
2006-10-14 10:36:47 · answer #1 · answered by O Caçador 6 · 3⤊ 0⤋
Geez, who do you work for- Enron? :)
I'd use a temporary column off to the right and multiply just the first one by -1. Then copy that formula to the entire range... Once it's done, just paste the new values back into the orignal column.
2006-10-14 08:29:48 · answer #2 · answered by C-Man 7 · 0⤊ 0⤋
You can't. You must enter negative numbers as following: Precede negative numbers with a minus sign (-), or enclose the numbers in parentheses ( ).
2006-10-14 08:31:05 · answer #3 · answered by Joe S 6 · 0⤊ 1⤋
subtract something
2006-10-14 08:26:34 · answer #4 · answered by Anonymous · 0⤊ 0⤋