| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add "+" plus symbol for a positive percentage
Also want to keep a "-" for a negative percentage and...
want a 0% to remain 0%. Right now I am using a custom cell format of +#0#%;-#0#% This works fine if it is a positive or negative 5% (i.e. +5% or -5%), but if it is a 0% it shows +0%. For a 0% I want it to not show a '+' or a '-'. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add "+" plus symbol to positive percentage | Excel Discussion (Misc queries) | |||
| excel displays "l" instead of "‚¬" symbol for Euro values | Excel Discussion (Misc queries) | |||
| How to Show "+" for positive and "-" for negative | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
Threaded Mode
