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 in Excel
REMOVE NEGATIVE SIGN FROM NUMBERS — EXCEL FORMULA AND EXAMPLE
REMOVE NEGATIVE SIGN FROM NUMBERS — EXCEL FORMULA AND EXAMPLE
=ABS(A2)
for % data: ABS(10%) = 0.1
the absolute formula will remove negative sing from a number and keep the same if the number is positive
Remove negative sign from numbers in Google Sheets
How to remove the negative sign from numbers in Google Sheets?Remove negative sign from numbers in Google Sheets
REMOVE NEGATIVE SIGN FROM NUMBERS — GOOGLE SHEETS FORMULA AND EXAMPLE
REMOVE NEGATIVE SIGN FROM NUMBERS — GOOGLE SHEETS FORMULA AND EXAMPLE
=ABS(A2)
for % data: ABS(10%) = 0.1
the absolute formula will remove negative sing from a number and keep the same if the number is positive
Other useful formulas to change number sign in Excel and Google Sheets
- Change the negative number to zero
- Change negative to positive numbers
- Change positive numbers to negative
- Calculate percentage changes for containing zero or negative values
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- Extract the nth words in a text string
- Flip the first and last name
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria