In VB how do I reverse a Negative number?

I have a calculation in Excel Cell that can create a negative zero. I would
like to change the negative to a positive in VB. How can this be done?
Rick

Hi Rick,

supposing x=-10

you can use:

1) -x 'to change the sign, if you know that x is always negative
2) abs(x) 'to get always positive number

Regards,
Ivan

How do you get a negative zero? My understating is that positive and
negative is defined from zero, so zero is neither.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rick" <Rick@discussions.microsoft.com> wrote in message
news:EE85EE2E-FEFE-462F-9D29-EE8A373865C3@microsoft.com...
> I have a calculation in Excel Cell that can create a negative zero. I
would
> like to change the negative to a positive in VB. How can this be done?
> Rick

How can you have a negative 0? Sounds like the display percision is showing a
non-zero as a 0.

"Rick" wrote:

> I have a calculation in Excel Cell that can create a negative zero. I would
> like to change the negative to a positive in VB. How can this be done?
> Rick