Some friends say they don’t know the Excel software yet, and they don’t know how to batch-convert negative numbers into positive numbers when editing tables. For this reason, the author here specifically shares a graphic tutorial on batch-converting negative numbers into positive numbers in Excel tables. Hope it helps you.
1. Open the Excel table, as shown on the right, one column is all negative numbers.
2. Enter the number -1 in any space.
3. Select the cell -1, right-click - copy,
4. 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),
5. After entering the Paste Special menu interface, select (Multiple) and click OK.
6. All negative numbers become positive numbers immediately.
The above article explains the operation process of batch converting negative numbers into positive numbers in Excel. I hope friends in need can learn it.
