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

ABS(num)

--
HTH

Bob

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

"NateBuckley" wrote in message
...
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

ABS

"NateBuckley" wrote:

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

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

=Abs(A1)

in another cell yields 654.

Hope this helps,

Hutch

"NateBuckley" wrote:

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

x=-x
--
Gary''s Student - gsnu200794


"NateBuckley" wrote:

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

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