View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by s7out View Post
I need a cell to equal another cell but flip it's "-" value to a "+" and to show it. In other words cell B2 = "-6.5". I need cell H2 to read "+6.5" (with the "+" visable. I normally would have this cell = '+6.5 however since this is a formula I don't know how to achieve the same result. Please advise. Thanks!
In H2 enter =ABS(B2) and then custom format H2 to +#