Optimize format for delta


When displaying delta percentages, I like to show them slightly different than hitting the standard % button.
Depending on the value, the – sign is not as visible, and I usually want to show a + sign before the positives as well:

display_deltas

This is accomplished by setting the cell format to custom and then :

_(* "+"???0%_);_(* "-"???0%_);"-"

When you want to display values instead of %’s, I prefer the following:

+* #,##0_-;-* #,##0_-;_-* "-"??_-;_-@_-

This is essentially the ACCOUNTING format, but it shows positive values with a plus (+) sign!