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!