Invert Negative number?

[NateBuckley]

Hello I'm just wondering if there is a built-in VBA function that'll invert
negative numbers so for example: -654 becomes 654.

Thanks for any help thrown my way.

Nate

 

[Bob Phillips]

ABS(num)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dennis]

ABS

 

[Tom Hutchins]

How about the Absolute function? For example, if A1 = -654

=Abs(A1)

in another cell yields 654.

Hope this helps,

Hutch

 

[Gary''s Student]

x=-x

 

[wolfman]

If by 'invert' you mean to negate negative numbers, use the ABS() function
then all conversions result in positive values. If you mean to swap positive
for negative (or vice versa) use the suggested x = -x or X = X*(-1). Hope
this helps