Formating tenths and hundreds to show as whole numbers

  • Thread starter Thread starter Nelson B.
  • Start date Start date
N

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?
 
A1 = 94%

A2 = 90%

A3 = (A1-A2)*100

A3 Custom format of "+"0"pts"


Gord Dibben MS Excel MVP
 
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.
 
Back
Top