Converting Negative numbers to positive numbers

[Mark]

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]

Have a look at the Abs function in the helpfile.

Dave

 

[John Vinson]

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.