Change negative to positive numbers in Excel and Google Sheets

=ABS(A2)

A2 = negative number cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Change negative to positive numbers in Excel

How to change negative to positive numbers in Excel?
Change negative to positive numbers in Excel

CHANGE NEGATIVE TO POSITIVE NUMBERS — EXCEL FORMULA

=ABS(A2)

  • A2 = data cell

  • for % data: ABS(10%) = 0.1

This formula will remove the negative sign and keep the same value if the cell has positive data

Change negative to positive numbers in Google Sheets

How to change negative to positive numbers in Google Sheets?
Change negative to positive numbers in Google Sheets

CHANGE NEGATIVE TO POSITIVE NUMBERS — GOOGLE SHEETS FORMULA AND EXAMPLE

=ABS(A2)

  • A2 = data cell

  • for % data: ABS(10%) = 0.1

This formula will remove the negative sign and keep the same value if the cell has positive data