How to turn a column of negative numbers into positive numbers in excel

Implementation method: First open the excel table, enter a negative number at any position; then right-click the mouse to select the number, and select "Copy" in the pop-up right-click menu; then select the negative number column that needs to be multiplied, and right-click the mouse , select "Paste Special"; finally, select "Multiply" from the "Operation" option in the pop-up menu, and click "OK".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the excel table, one column is all negative numbers.

Enter the number -1 in any blank box

Select the cell -1, right-click--- -Copy

,

and then select all the negative numbers you need to change, right-click--Paste Special---Paste Special (note that the 2010 version is a two-level menu)

After entering the Paste Special menu interface, select (Multiply) and click OK

All negative numbers immediately become Positive numbers

# Related learning recommendations: excel tutorial

The above is the detailed content of How to turn a column of negative numbers into positive numbers in excel. For more information, please follow other related articles on the PHP Chinese website!