How to convert negative numbers to positive numbers Excel
When presenting or editing spreadsheet data in Excel, you need to convert negative numbers into positive numbers or vice versa from positive numbers to negative numbers. If making a manual switch to delete each negative sign is only appropriate when the Excel table has little data, there are many columns of data, this approach is not feasible. In fact, to convert negative numbers to positive numbers, or vice versa on Excel is very simple without using complicated Excel functions. The following article will guide you how to convert negative numbers to positive numbers and vice versa on Excel.
- Instructions to stamp negative numbers in Excel
- Instructions for separating column content in Excel
- How to convert money into words in Excel
- How to display 0 in front of a number in Excel
How to 1. Change the number to positive numbers with Paste Special
For example, I have the Excel data table below with a negative number like the image.
How to convert negative numbers to positive numbers Excel Picture 1
Step 1:
First of all, enter the -1 number into any empty cell on the Excel table.
How to convert negative numbers to positive numbers Excel Picture 2
Step 2:
Then click copy this -1 and then black out all negative numbers to convert to positive numbers. If there is a negative number in each position, then press Ctrl and click on each of them, select the right mouse button.
How to convert negative numbers to positive numbers Excel Picture 3
Right-click and choose Paste Special or click the arrow at the Paste button on the Home tab of the ribbon bar, then also select Paste Special.
How to convert negative numbers to positive numbers Excel Picture 4
Step 3:
Display the new dialog interface and click on Multiply and click OK as shown.
How to convert negative numbers to positive numbers Excel Picture 5
The entire negative number column has been converted to positive numbers with a very fast way.
How to convert negative numbers to positive numbers Excel Picture 6
Method 2: Use the IF function to convert negative numbers to positive
In case your data column has many positive and negative numbers alternating with each other, but you want to change negative numbers to positive numbers, you can use the IF function.
Step 1:
We have the data table below and also enter the number -1 at any position you want.
How to convert negative numbers to positive numbers Excel Picture 7
Step 2:
In cell G3, enter the formula = IF (E2 <0, E2 * $ G $ 1, E2). In which, if the value of cell E2 is less than 0, multiply by G1, if the value is greater than 0, remain the same.
How to convert negative numbers to positive numbers Excel Picture 8
Step 3:
Press Enter and see the value converted to positive numbers. Clicking on the box and then dragging down the remaining cells will display the results as shown.
How to convert negative numbers to positive numbers Excel Picture 9
Step 4:
Copy all the data from G2 to G6 and black out the column E2 to E6 and right-click and choose Paste Special , or click the arrow in the Paste button on the Home tab of the menu bar, then select Paste Special.
How to convert negative numbers to positive numbers Excel Picture 10
Step 5:
In the display interface, click on Values and click OK.
How to convert negative numbers to positive numbers Excel Picture 11
Immediately the value in G2 to G6 column has shifted to column E2 to E6 as shown.
How to convert negative numbers to positive numbers Excel Picture 12
2 ways to convert negative numbers to positive numbers or vice versa on Excel are very simple. For the second way, the IF function automatically filters out values less than 0 to multiply by -1, if the data column mixes two types of numbers together. Depending on how your data column is, we choose the appropriate usage.
I wish you all success!
You should read it
- Instructions to stamp negative numbers in Excel
- How to separate negative and positive numbers in Excel
- Convert numbers to text in Excel
- PI (PI Function) in Excel - How to use PI numbers in Excel
- Split numbers from strings in Excel
- How to convert Apple Numbers documents to Microsoft Excel
- How to format numbers in Excel
- Instructions to change phone numbers associated with home banking
- How to extract numbers or text from Excel
- How to convert numbers into words in Excel?
- How to Add Autonumber in Excel
- How to round whole numbers in Excel