# Help with this formula

s7out
Guest
Posts: n/a

 25th Jul 2012
I need a cell to equal another cell but flip it's "-" value to a "+" and toshow 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!

Claus Busch
Guest
Posts: n/a

 25th Jul 2012
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

jsofillas@gmail.com
Guest
Posts: n/a

 25th Jul 2012
On Wednesday, July 25, 2012 9:39:41 AM UTC-4, Claus Busch wrote:
> Hi,
>
> Am Wed, 25 Jul 2012 06:26:55 -0700 (PDT) schrieb s7out:
>
> &gt; I need a cell to equal another cell but flip it's &quot;-&quot; value to a &quot;+&quot; and to show it. In other words cell B2 = &quot;-6.5&quot;. I need cell H2 to read &quot;+6.5&quot; (with the &quot;+&quot; 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 &quot;+&quot;General&quot;
>
> Regards
> Claus Busch
> --
> Win XP PRof SP2 / Vista Ultimate SP2
> Office 2003 SP2 /2007 Ultimate SP2

I can't get the + to show. Under Custom in the number formatting options, what exactly do i type in the space to get this to work? Thanks.

zvkmpw
Guest
Posts: n/a

 26th Jul 2012
> I can't get the + to show. Under Custom in the number formatting options,
> what exactly do i type in the space to get this to work?

I tried
+0.0;-0.0
for the custom formatting type and it seems to display what you want.

Notice that for zero it shows
+0.0
If you don't want the + to show in this case, try this instead
+0.0;-0.0;0.0

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?bGVjYWJhbGxlcm8=?= Microsoft Excel Programming 1 2nd Nov 2005 12:46 PM Jonathan Windows XP General 10 13th Jan 2005 03:22 AM =?Utf-8?B?U2FuYXRhcml1bV83?= Windows XP General 2 25th Sep 2004 04:00 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM Muxer Microsoft Excel Programming 2 24th Jul 2003 01:02 AM

Features