Always negitive

H

HessInAMess

is there a way to tell excel to always make any numbers in a cell
negitive? even when the number wasn't entered with a - sign? I've been
trying to use the format cells options to do this and using the custom
formats i can have it add a - sign in front of the number but it
doesn't actually make the number negitive.
 
F

Frank Kabel

Hi
if you want to change them you'll need VBA to scan all cells and negate
the values if required.

But if you just want to use them for further calculations you may use
something like
=-ABS(A1)
 
H

HessInAMess

Thanks, i finally got it all working. i appreciate your help. I was
able to use =-SUM to add together the cells i wanted and then turn it
to a negitive number.
 
Top