Thread: Negative format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alvin Hansen[_2_] Alvin Hansen[_2_] is offline
external usenet poster
  
Posts: 209
Default 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

Reply With QuoteReply With Quote