1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to hide zeros in a table but keep relevant decimals?

I am having a hard time figuring out the custom text in cell formatting to hide zeros.

What I want to hide:

  • 0
  • 0.00

With just Div/0 error corrected

When I use this custom formula 0;-0;;@ in the custom text formatting it deletes all of my decimals in my table.

Using 0;-0;;@ custom formatting, which removes all zeros, including decimals

Basically, I am trying to have my table show nothing if all the data is zero (because there is no data yet) while still maintaining the formulas. I have removed the Div/0 error, but I cannot figure out the custom text needed to get rid of the zeros while still keeping my decimals.

I would love to avoid conditional formatting if at all possible. I saw some people just change the text to white. That won't work for me because I use different colors in my Excel workbook.

Is there a custom text I can use to achieve what I am trying to do?

submitted by /u/MinorFX
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article