Change Dashes To Zeroes In Excel

I might be alone in this, but I hate seeing hyphens in lieu of 0’s in tables and charts. Here’s what it looks like:

 

To change these dashes to 0’s select either the column or axis and press Ctrl/Command-1 to open formatting options. The formula, if you will follows this structure:

Positive; Negative; Zero; Text

So just look for “-“?? after the second semicolon and change it to a 0. Easy peezy!

You can learn more about custom number formatting from the Microsoft site.

Learn More

For more beastly data visualization tips, check out out my Annielytics Dashboard Course offerings.

Image Credit: Markus Spiske on Unsplash