How to convert a negative number into positive in Excel
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
You can watch a video tutorial here.
There are times when having negative numbers are unnecessary and the negative sign should be taken out. By using the ABSOLUTE command, negative numbers will be turned into positive.
Step 1 – Click on an empty cell
Clicking on an empty cell, gives you the option to create a formula to turn the negative number into positive.
Step 2 – In the formula bar, type in “=ABS(cell)”. The cell symbolizes the number that needs to be converted into positive. Then press Enter
In this example, A1 is the number being designated as the cell to be converted.
