How to remove negative sign using custom number format

[noora19]

Hello,

I was wondering if anyone knew how to remove a negative sign from a value in excel using a custom number format? This value would need to appear and treated as a positive number. Is there a way to do this?

Thanks in advance!

 

[Jonmo1]

Welcome to the board.

You can't do it with a format..
Formats only change the appearance of the value, they do not effect the actual value of the cell. So it would not be "Treated" as positive.

You'll have to use a formula to convert negatives to positive...
Try ABS

=ABS(A1)


Hope that helps.

 

[noora19]

Got it. Thanks! I will use that.