In this article, I will introduce some formulas which can quickly change negative numbers to positive numbers in Excel Office 365. Just follow the instructions below and achieve the task. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- Use the below-mentioned formula to change negative numbers to positive numbers in Excel.
=[ABS](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)(number)
Syntax Explanation
- ABS – The ABS (Absolute) function returns the absolute value of a number. A number without its sign is known as the absolute value of a number.
- Parenthesis () – The purpose of this symbol is to group the elements.
Practical Examples
Use the following steps to change negative numbers to positive numbers in Excel.
- For instance, you have to create a sample data in Excel.
Sample data
- To change negative numbers to positive, you need to use the following formula in formula bar.
=[ABS](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)(B6)
Use the Formula
- Then, you have to Hit the Enter key to get the result in the cell C6 as shown below.
Result for cell C6
- Now, you need to press Ctrl+D key to get the results in all other columns.
Output
Summary
In the above article, you can easily understand the steps to change negative numbers to positive numbers using Formulas in Excel Office 365. Don’t forget to share your feedback with us. Thank you so much for visiting Geek Excel!! Keep Learning! If you want to learn more helpful formulas, check out Excel Formulas !!
Further Reference:
- How to Separate Negative and Positive Values From a Column in Excel?
- Formulas for Counting Cells that Contain Negative Values in Excel!!
- Formulas to Count Cells that contain Positive Numbers in Excel!!
- How to Change the Signs of Numbers in Excel Office 365? – Quick Steps!!
- How To Add Only Distinct Positive Values with Excel VBA?
Top comments (0)