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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#row zero
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#real-time collaboration