Prev: dowloading data of CSV file to excel file
Next: Change format
From: Nelson B. on 15 Mar 2010 15:01
I have a need to show the difference between percents as a change in points.

For example, if a metric changes from 90% to 94% (+.04), I would like to
display the .04 as +4pts. Is there a way to do this via formating?
From: "David Biddulph" groups [at] on 15 Mar 2010 15:12
No.
--
David Biddulph


"Nelson B." <NelsonB(a)discussions.microsoft.com> wrote in message
news:A4272D44-03A0-4482-8EFD-A14BC5EEBD32(a)microsoft.com...
> I have a need to show the difference between percents as a change in
> points.
>
> For example, if a metric changes from 90% to 94% (+.04), I would like to
> display the .04 as +4pts. Is there a way to do this via formating?


From: Gord Dibben on 15 Mar 2010 15:33
A1 = 94%

A2 = 90%

A3 = (A1-A2)*100

A3 Custom format of "+"0"pts"


Gord Dibben MS Excel MVP


On Mon, 15 Mar 2010 12:01:01 -0700, Nelson B.
<NelsonB(a)discussions.microsoft.com> wrote:

>I have a need to show the difference between percents as a change in points.
>
>For example, if a metric changes from 90% to 94% (+.04), I would like to
>display the .04 as +4pts. Is there a way to do this via formating?

From: Gary Brown on 15 Mar 2010 16:00
You can use this custom format...
+#,##0.00 "pts"_);-#,##0.00 "pts")
but you're going to have to multiply the answer by 100 first.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Nelson B." wrote:

> I have a need to show the difference between percents as a change in points.
>
> For example, if a metric changes from 90% to 94% (+.04), I would like to
> display the .04 as +4pts. Is there a way to do this via formating?
 | 
Pages: 1
Prev: dowloading data of CSV file to excel file
Next: Change format