Do you know the free online spreadsheet editor -Google Sheets?

Do you have any idea how to convert negative numbers to positive in Google Sheets?

This article fromMiniToolshows you several ways to achieve this goal.

use the ABS function

In previous articles, MiniTool has introducedhow to download Google Sheetsandthe differences between Google Sheets and Microsoft Excel.

In this post, you could find some useful methods to turn negative numbers into positive in Google Sheets.

Method 1.

drag the fill handle

The ABS statement gives theabsolute valueof any field.

It means that all negative numbers will be changed to positive using ABS.

Here is how to do that.

replace the negative sign to blank

Step 1. jot down=ABS(value)in the cell you want to return a positive number.

Thevaluerefers to the negative number or the accurate cell.

Related post:How to Fix the Formula Parse Error in Google Sheets?

type =UMINUS(C1)

Method 2.

Use Find and Replace

The second way is to use theFind and replacefunction.

you might follow the steps below.

type =C1*-1

Select a cell and clickEditin the toolbar.

Then selectFind and replace(or pressCtrl + H).

Step 2. bang out (the negative sign)in theFindbox and bang out nothing in theReplace withbox.

start Power Tools

After that, clickReplace allto apply the operations.

Method 3.

Use the UMINUS Function

In Google Sheets, UMINUS returns a number with the sign reversed.

choose Convert

And the steps are very similar to using ABS.

First, bang out=UMINUS(value)in a cell.

Thevaluealso refers to the negative number or the accurate cell.

start to convert the number sign

For example, typing=UMINUS(C1)or=UMINUS(-17)as shown in the picture below.

Method 4.

You just need to bang out=value*-1in a cell.

6 Ways to Recover Sticky Notes in Windows 10/11 Easily

Also, thevaluerefers to the negative number or the accurate cell.

For multiple negative numbers, you could also drag thefill handleas described above.

Method 5. you’re free to clickhereto install it in your Chrome if you do not have this tool yet.

And follow the steps below to convert negative numbers to positive in Google Sheets.

ClickExtensions>Power Tools>Start.

Wait a few seconds and chooseConvertin the interface of Power Tools.

Choose theConvert number signand selectConvert negative numbers to positive.

Then select all wanted cells and clickRun.

Wait for the process to complete and the numbers should be changed.

Do you know how to recover Sticky Notes if they are deleted accidentally?

This post shows you several useful methods to get deleted or lost Sticky Notes back.

you could download it and try it out.

you’ve got the option to share your favorite methods in the comment zone below.