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