• Wendy Ni

How to Change Negative to Positive Numbers in Google Sheets

Objective Advantages

We've all been there. We pulled a bank statement and found ourselves with some negative numbers that through some things off. In this blog, we will walk you through a simple formula that you can use to change negative numbers to positive numbers. We also add a quick tip at the end to make sure you don't have any issues with this simple trick.

Steps to Convert Negative to Positive in Google Sheets

  • In Google Sheets, start with the column that has negative data

  • To the right of the column, insert a blank column

  • In the new empty column, type the following in a cell: =ABS(cell value)

  • The cell value should be the number that is negative you want to change to positive

  • Drag the bottom right corner down or use the shortcut: Shift + Ctrl + arrow keys (this allows you to quickly select a large range of cells)

  • Copy all the values in the positive column, and paste values only in the column with all the negative values

  • Delete the extra column (that used the formula)

For a more visual tutorial, here is the video.

Check out this blog on combining two cells in Excel.



#googlesheets #google #sheets #negative #positive #numbers #convert #formula #bankstatement #howto #values #data #qbo #excel #bookkeeping #financialservices #accounting #financialgps

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Grey Instagram Icon

©2019 All Rights Reserved 

Philadelphia, PA | New York City, NYC | hello@FinancialGPS.co