Working with negative numbers

[Scroopy]

Hello,

I have a macro that captures a number from a cell and puts it into a variable; however, when that number is a negative, it seems to be be stored as a positive in the variable. I would just like to know how to keep the number as a negative (if it is a negative) in the variable.

Cheers,

[Bob Phillips]

Sounds ood, show us the code.