Custom Number Formats?
Rather than showing a 0 in a cell, I'd like it be be blank or use the " - " symbol. In excel I use custom number formats to accomplish this.
First, I tried conditional formatting to a white (invisible) font, but it doesn't look like i can limit the rule to certain cells (only an entire row or column) so that won't work if there is shading (the white makes the 0 visible).
Then I tried using a formula but when a text cell shows up in a range, the formulas either break (error message) or the total in the header row changes to general text (no commas or decimals).
Any direction would be appreciated
Help Article Resources
Check out the Formula Handbook template!