App Tutorial

Convert Negative to Positive Numbers in Google Sheets: 5 Methods

Jason Gong
App automation expert
Apps used
Google Sheets
April 15, 2024

To convert negative numbers to positive in Google Sheets, use the ABS function, Find and Replace, UMINUS function, multiplication by -1, or Power Tools add-on. Each method caters to different needs, ensuring flexibility for your data management.

Choosing the right method depends on your specific data context and workflow efficiency.

Streamline your Google Sheets data management and ensure accuracy with Bardeen's automation capabilities.

How to Convert Negative Numbers to Positive in Google Sheets

Converting negative numbers to positive numbers in Google Sheets can be essential for data analysis, financial modeling, or simply cleaning up your data. Google Sheets provides several methods to achieve this, ensuring flexibility depending on your specific needs. Below are detailed explanations of these methods.

Automate your Google Sheets and save time on data conversion with Bardeen. Explore how at

Google Sheets Convert Negative to Positive

To change negative numbers to positive in Google Sheets, you can use the ABS function, Find and Replace feature, UMINUS function, multiplication by -1, or an add-on like Power Tools. Each method serves the same purpose but differs in application based on the context of your data.

Google Sheets Absolute Value

The ABS function is the most straightforward method to convert negative numbers to positive. It returns the absolute value of a number, effectively removing its sign.

To use the ABS function:

  1. Type '=ABS(value)' in a cell, replacing "value" with the negative number or the cell reference containing the negative number.
  2. Press Enter to apply the formula. The cell will now display the positive value of the number.

For multiple numbers, you can drag the fill handle to apply the formula to adjacent cells.

Change Negative to Positive in Google Sheets Using Find and Replace

The Find and Replace feature can also be used to quickly convert negative numbers to positive by removing the negative sign:

  1. Select the range of cells containing the negative numbers.
  2. Go to the Edit menu and choose Find and Replace (or press Ctrl + H).
  3. In the Find box, type the negative sign (-) and leave the Replace with box empty.
  4. Click Replace all to remove the negative signs, converting the numbers to positive.

How to Make Negative Numbers Positive in Google Sheets Using UMINUS and Multiplication

Other methods include the UMINUS function and multiplying by -1:

  • UMINUS Function: Type '=UMINUS(value)' in a cell, where "value" is the negative number or cell reference. This function reverses the sign of the number.
  • Multiplication by -1: Type '=value*-1' in a cell, where "value" is the negative number or cell reference. This method multiplies the negative number by -1, converting it to a positive number.

Both methods can be applied to individual cells or dragged across a range to convert multiple numbers.

Using Add-ons for Conversion

For a more automated approach, the Power Tools add-on for Google Chrome can convert negative numbers to positive:

  1. Install the Power Tools add-on from the Google Workspace Marketplace.
  2. Open the add-on and select the Convert tool.
  3. Choose 'Convert number sign' and select 'Convert negative numbers to positive'.
  4. Select the cells you wish to convert and click Run.

This method is particularly useful for large datasets or when looking to streamline the conversion process.

Discover powerful Google Sheets automations to enhance your data management. Learn more on Google Sheets add-ons, automation, and more.

Each of these methods provides a reliable way to convert negative numbers to positive in Google Sheets, ensuring that you can choose the one that best fits your workflow and data structure.

Automate Google Sheets Tasks with Bardeen

While converting negative numbers to positive in Google Sheets can be done manually using several methods, automating this process can save you a significant amount of time, especially if you're dealing with large datasets. Automation can also reduce the risk of human error, ensuring that your data stays accurate and consistent. For those looking to streamline their workflow, Bardeen offers powerful automation capabilities that can make managing your Google Sheets data more efficient.

  1. Copy an email with a negative sentiment to Google Sheets, when a new email is received: This playbook automates the process of analyzing the sentiment of incoming emails and saving those with a negative sentiment to a Google Sheets spreadsheet. It's an excellent example of how you can use automation to monitor and categorize data based on specific criteria.
  2. Send a Slack message counting the rows in a Google Sheet: If you need to keep your team updated on the status of your Google Sheets data, this playbook automates the process of counting rows in a sheet and sending a message through Slack. It's a useful tool for project management and team collaboration.
  3. Enrich email contacts and save to Google Sheets: For those involved in email marketing or customer outreach, this playbook automates the process of enriching email contacts with additional information and saving them to Google Sheets. This can help you build more detailed customer profiles and improve your marketing strategies.

Each of these playbooks demonstrates just a fraction of what's possible with Bardeen's automation capabilities. By automating routine tasks in Google Sheets, you can free up more time to focus on analysis and decision-making. Get started by downloading the Bardeen app at

Other answers for Google Sheets

How to Disable Download Option in Google Sheets

Learn how to disable downloads in Google Sheets by adjusting share permissions and protecting sheets, enhancing data security.

Read more
How to Download Specific Parts of Google Sheets

Learn how to download specific parts of Google Sheets using the sheet's GID for efficient data sharing and analysis. Streamline your workflow today.

Read more
How to Download Images and Charts from Google Sheets

Learn how to download images and charts from Google Sheets directly or from a URL list to Google Drive, including step-by-step instructions.

Read more
How to Convert Google Sheets to Excel

Learn to download Excel from Google Sheets in a few steps, ensuring file compatibility and offline access. Perfect for Excel users.

Read more
Effective Methods to Convert Numeric Dates to Written Months

Learn how to convert numeric dates to written months in Google Sheets using TEXT function, custom formatting, and more for enhanced data presentation.

Read more
Convert Time to Text in Google Sheets

Learn how to convert time to text in Google Sheets using the TEXT function and built-in formatting options for clear data presentation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.