How to Convert Negative Numbers to Positive in Google Sheets - MiniTool

Google Sheets Five ways to turn negative numbers into positive numbers

This article will introduce several ways to convert negative numbers to positive numbers in Google Sheets.

Method 1: Use ABS function

The easiest way is to use the ABS function. ABS function returns the absolute value of any number, which means that all negative numbers will be converted to positive numbers.

Step 1: Enter =ABS(value) in the cell where you want to display a positive number. where value refers to a negative number or cell reference.

For example, enter =ABS(-17) or =ABS(C1) in cell E1, and E1 will display 17 .

Step 2: To convert multiple negative numbers of the entire row or column at once, drag the fill handle of cell E1.

Method 2: Use the search and replace functions

The second method is to use the Find and Replace feature.

Step 1: Select a cell, click Edit in the toolbar, and select Find and Replace (or press Ctrl H).

Step 2: Enter – (negative sign) in the Find box and leave blank in the Replace with box. Then set the search range, here the example is C1:C4.

Click "Replace All" to apply the action.

Method 3: Use UMINUS function

UMINUS function returns numbers with opposite symbols. Therefore, it is also a way to convert negative numbers to positive numbers (or vice versa) in Google Sheets. The steps are very similar to using the ABS function.

First, enter =UMINUS(value) in the cell. value also refers to a negative number or cell reference.

For example, enter =UMINUS(C1) or =UMINUS(-17) as shown in the figure.

Secondly, to change multiple numbers at once, you can also drag the fill handle icon in the lower right corner of the cell.

Method 4: Multiply by -1

Because multiplying negative numbers by -1 will become positive, you can use this method to convert negative numbers to positive numbers in Google Sheets.

Simply enter =value*-1 in the cell. value also refers to a negative number or cell reference.

For multiple negative numbers, you can also drag the fill handle as described above.

Method 5: Use add-on components

There is an extension in the Google Chrome browser called "Power Tools" that can help you better manage Google, and converting numeric symbols is a feature of this tool.

If you don't have this tool yet, you can click here to install it in Chrome. Then follow the steps below to convert the negative number to a positive number.

Step 1: Click "Extensions" > "Power Tools" > "Start".

Step 2: Wait for a few seconds, and then select Convert in the Power Tools interface.

Step 3: Select Convert Number Symbols and select Convert Negative Numbers to Positive Numbers. Then select all the cells you want and click Run.

Step 4: Wait for processing to complete, the number should have been changed.

Summarize

This article describes several ways to change negative numbers to positive numbers in Google Sheets. You can share your favorite method in the comment section below.

If you have more interest in Google Sheets or computers, you can visit the MiniTool News Center.

The above is the detailed content of How to Convert Negative Numbers to Positive in Google Sheets - MiniTool. For more information, please follow other related articles on the PHP Chinese website!