Convert Negative Number to Positive 🫢 (Excel Tips)

Convert negative number to positive number in Excel easily using two different methods.

One method shows how to convert a negative number to positive using a formula, and the second method is a quick Excel tip.

Connect with us!

#excelshorts #excel #exceltips

[arnessad]

I used the option #2 and it worked!! Very simple!! Thanks!!

[neeshirey]

I LOVE method #2! So simple, so elegant - thank you so much!

[dve]

Or formula of =-A2 will work if all your numbers are negative and you want the positive.

[meniporat]

If all numbers are negative,
=-(A2:A6) will convert all of them at once
Same applies to
=ABS(A2:A6)

[salamwest]

You can press control+h the replace the negatives all in just one click