Converting negative numbers to positive in a spreadsheet column
spreadsheet with column containing several hundred rows of negative numbers, is there a way to convert them to positive numbers
[Re-Titled by Moderator]
MacBook Pro 13″, macOS 15.2
Question marked as
Hi Johnny,
If all values are negative,
Formula in C2 is −B2
Fill down.
If values are some negative and some positive, we need an IF statement:
IF(B2<0,−B2,B2)
Regards,
Ian.