Excel Tip: How to Not Show Zero Values in Percentages

Often not showing zero values in Excel makes data easier to read.  Percentages by default display zeroes; if you want to replace that with a dash, blank, etc. use the following formula in the Custom Format section:

0.00%;-0.00%;"-"  (you can replace the "-" with blanks (" ") or anything else)

The easiest way to bring up the dialog is by hitting CTRL+1, which will get you what you see here:

If you're curious how Custom Formats work in Excel, check out these these great articles on the topic:

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.