Help with this formula
Hi,
Am Wed, 25 Jul 2012 06:26:55 -0700 (PDT) schrieb s7out:
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!
try in H2:
=ABS(B2)
and use custom numberformat "+"General"
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|