J JE McGimpsey Nov 8, 2004 #3 If it's a recurring need, one way: B1: =ABS(A1) If it's a one-time need, one way: Put -1 in a cell. Copy the cell. Select the cells to negate. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons.
If it's a recurring need, one way: B1: =ABS(A1) If it's a one-time need, one way: Put -1 in a cell. Copy the cell. Select the cells to negate. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons.
N Niek Otten Nov 8, 2004 #4 Note that if the selection contains positive numbers too, they will change to negative. -- Kind Regards, Niek Otten Microsoft MVP - Excel
Note that if the selection contains positive numbers too, they will change to negative. -- Kind Regards, Niek Otten Microsoft MVP - Excel
