Remove the negative sign from numbers in Excel and Google Sheets

=ABS(A2)

A2 = data cell

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

Remove negative sign from numbers in Excel

How to remove the negative sign from numbers in Excel?

REMOVE NEGATIVE SIGN FROM NUMBERS — EXCEL FORMULA AND EXAMPLE

=ABS(A2)

Remove negative sign from numbers in Google Sheets

How to remove the negative sign from numbers in Google Sheets?

REMOVE NEGATIVE SIGN FROM NUMBERS — GOOGLE SHEETS FORMULA AND EXAMPLE

=ABS(A2)