Excel Formula to Change negative numbers to positive Numbers!!
Tags: excelformula, excelformulas
Published: 2021-11-03 02:28:57

---
title: Excel Formula to Change negative numbers to positive Numbers!!
published: true
date: 2021-11-02 10:12:56 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-to-change-negative-numbers-to-positive-numbers/
---

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](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.

![](https://geekexcel.com/wp-content/uploads/2021/11/Sample-data-10.png)
_Sample data_

- To change negative numbers to positive, you need to use the following formula in **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[ABS](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)(B6)

```

![](https://geekexcel.com/wp-content/uploads/2021/11/Use-the-Formula-13.png)
_Use the Formula_

- Then, you have to  **Hit the Enter key**  to get the result in the **cell C6** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/11/Result-for-cell-C6.png)
_Result for cell C6_

- Now, you need to  **press Ctrl+D key**  to get the results in all other columns.

![](https://geekexcel.com/wp-content/uploads/2021/11/Output-4.png)
_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](https://geekexcel.com/)!!** Keep Learning! If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Further Reference:**

- **[How to Separate Negative and Positive Values From a Column in Excel?](https://geekexcel.com/how-to-separate-negative-and-positive-values-excel/)**
- **[Formulas for Counting Cells that Contain Negative Values in Excel!!](https://geekexcel.com/formulas-for-counting-cells-that-contain-negative-values-in-excel/)**
- **[Formulas to Count Cells that contain Positive Numbers in Excel!!](https://geekexcel.com/formulas-to-count-cells-that-contain-positive-numbers-in-excel/)**
- **[How to Change the Signs of Numbers in Excel Office 365? – Quick Steps!!](https://geekexcel.com/how-to-change-the-signs-of-numbers-in-excel-office-365-quick-steps/)**
- **[How To Add Only Distinct Positive Values with Excel VBA?](https://geekexcel.com/how-to-add-only-distinct-positive-values-with-excel-vba/)**