Formating tenths and hundreds to show as whole numbers

[Nelson B.]

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?

 

[Gord Dibben]

A1 = 94%

A2 = 90%

A3 = (A1-A2)*100

A3 Custom format of "+"0"pts"


Gord Dibben MS Excel MVP

 

[Gary Brown]

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.