Custom Number Formats?

Gregg Wolin

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

Andrée Starå

Hi @Gregg Wolin

I hope you're well and safe!

You could use a Workflow with the change cell value action.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!