• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Excel Tutorials by Y. Acosta

Excel Tutorials + Tips

  • Excel Tutorials
  • Etsy Store
  • Other Resources
  • About Me
    • About Me
    • Contact Me
    • FREE Printable List of Top Excel Keyboard Shortcuts
  • FREE pdf of Top Excel Shortcuts!

4 Ways: Change Negative Numbers to Positive in Excel (+ video tutorial)

❤ Support Free Excel Training by Sharing -

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

A subscriber recently asked me how he could change a range of cells from negative to positive in Excel. He received a file that included a group of negative values (sold inventory), but needed to convert the entire range to positive for a project he was working on. This is what we discussed:

How to Convert Negative Numbers to Positive in Excel: 4 Ways!

Watch: Change a Range of Cells from Negative to Positive in Excel (video tutorial)

1.     Use the Absolute Function: =ABS()

The Absolute function in Excel returns the positive value of a given cell. Applying the Absolute function to a range of cells will change the negative numbers to positive, while not affecting any values that were already positive. To use the Absolute function:

  • In a blank area of your spreadsheet (that is large enough to be the same size as the original range of cells), type =ABS and reference the first cell in your original range of numbers
  • Then, copy and paste this so that you create a new range that mirrors your original range
  • Finally, copy the new values and paste over the original range by using Paste Special / Values
  • Once done, you can delete where you calculated the ABS function
Absolute Function in Excel Example
Absolute Function in Excel Example

2.     Multiply Group of Negative Values by -1

You can also make negative values positive by multiplying them by -1.

  • First, type -1 in a free cell in your spreadsheet
  • Then, in a blank area of your spreadsheet that is large enough to be the same size as the original range of cells, type a formula to reference the first cell in the range with the negative values and multiply by the cell with the -1
  • Press F4 to make the cell with the -1 an absolute reference (you should see the $ signs like in $A$1) and press Enter
  • Copy the formula and paste it in an area that mirrors your original range
  • Copy these results and, using Paste Special / Values, paste over the original range of negative cells
  • Once done, delete the cells with the calculation
Multiply Range of Negative Values by -1 Example
Multiply Range of Negative Values by -1 Example

3.     Multiply Group of Negative Values by -1 using the Paste Special, Multiply Operation

An easier way to change negative values to positive in Excel is by multiplying by -1 in mass. You can do this by using Paste Special.

  • First, type -1 in a cell in your spreadsheet and copy it
  • Then select all the cells in the range that contains the negative values
  • Right-click to select Paste Special
  • In the Operation section, select Multiply and press OK
Paste Special / Operation section / Multiply option
Paste Special / Operation section / Multiply option

4.     Use Find & Replace to Change Negative Numbers to Positive

The fourth way you can change your negative numbers to positive will work if your cells do not contain any formulas. That is, if your cells contain only the negative values, but no calculations.

  • Highlight to select the range of cells with the negative values, press Ctrl+H to bring up Find & Replace
  • In the Find what field, type a negative sign (-)
  • In the Replace with field, type nothing. I like to backspace and delete to make double sure there’s nothing there.
  • Press Replace All (or “Replace” if you want to review each instance).
Use Find & Replace to Change Negative Values to Positive in Excel Example
Use Find & Replace to Change Negative Values to Positive in Excel Example


Change Group of Negative Cells in Excel to Positive (pin for Pinterest)

Related Articles:

  • RANDARRAY in Excel - Tutorial (featured image)
    How to Use the RANDARRAY Function to…
  • Excel Slider with Percentages (feat. image, thumbnail)
    Make a Slider with Percentages in Excel (+…
  • Create Links to Other Sheets (feat. image)
    Ways to Link Sheets in Same Excel Workbook…

❤ Support Free Excel Training by Sharing -

blank

About Y. Acosta

Yil's (pronounced like "Jill") passion for Excel spreadsheets can be traced back to her days in marketing, where she spent significant time working on analytics. As a content creator, she now specializes in Excel spreadsheet tutorials. Make sure to visit the About page to learn more.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Follow us:

Latest Tutorial:

Featured image for How to Use Find & Replace to Remove Wildcard Characters in Excel article

Click Here for More Excel Tutorials!!!

Get Your FREE pdf of Top Excel Keyboard Shortcuts!

* indicates required

blank

Image-button for Invoice Template for Etsy

Copyright © 2025

  • Home
  • Excel Tutorials
  • Resources
  • About Me
  • Privacy Policy & Terms of Use
  • Disclaimer
  • Advertiser Disclosure
  • Contact Me
  • FREE Printable List of Top Excel Keyboard Shortcuts
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
SettingsAccept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT