Converting Negative numbers to positive numbers

Mark · Jul 28, 2003

Hi all,

Is there a VBA function to convert a negative number to a positive number?

Thanks for your help

Kind Regards
Mark.

Dave Jones · Jul 28, 2003

Have a look at the Abs function in the helpfile.

Dave

John Vinson · Jul 28, 2003

Hi all,

Is there a VBA function to convert a negative number to a positive number?

Yes: Abs()

Absolute Value function; e.g. Abs(13) = Abs(-13) = 13.