| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating tenths and hundreds to show as whole numbers
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating tenths and hundreds to show as whole numbers
No.
-- David Biddulph "Nelson B." wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating tenths and hundreds to show as whole numbers
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. 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formating tenths and hundreds to show as whole numbers
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating to Show Numbers NOT Divisible by another | Excel Worksheet Functions | |||
| show to stop scientific numbers from general formating | Excel Discussion (Misc queries) | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| Formating to show square meters ie m2 | Excel Discussion (Misc queries) | |||
Linear Mode
