Negative format
 

Hi

How can i make this
til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2)

So the value in beregnforsikring!$q$1 become negative.

regards alvin

Negative format
 

Hei Alvin

In very general, what these things do is taking whatever meaningful from the
right side of the = and put this result to the lucky winner on the left
side. So what you do here is setting the til1pris value, you are not
changing the q1 value.

But the code is a little mysterious. Please provide some more detail.

HTH. Best wishes Harald

"Alvin Hansen" skrev i melding
...
Hi

How can i make this
til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2)

So the value in beregnforsikring!$q$1 become negative.

regards alvin

Negative format
 

til1pris.Value = FormatNumber( _
Range("beregnforsikring!$q$1").Value * -1, 2)

--
Regards,
Tom Ogilvy


"Alvin Hansen" wrote in message
...
Hi

How can i make this
til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2)

So the value in beregnforsikring!$q$1 become negative.

regards alvin

Negative format
 

Thanks again tom
Regards alvin


"Tom Ogilvy" skrev:

til1pris.Value = FormatNumber( _
Range("beregnforsikring!$q$1").Value * -1, 2)

--
Regards,
Tom Ogilvy


"Alvin Hansen" wrote in message
...
Hi

How can i make this
til1pris.Value = FormatNumber(Range("beregnforsikring!$q$1").Value, 2)

So the value in beregnforsikring!$q$1 become negative.

regards alvin