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

Our take

Hiding zeros in a table while preserving relevant decimals can enhance clarity, especially when data is still being collected. If you're facing challenges with custom text formatting, the common approach of using "0;-0;;@" often results in the loss of decimal values. Instead, consider a custom format that retains decimal places while displaying nothing for zero values. This allows your formulas to remain intact and your data presentation to be cleaner.

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]

Read on the original site

Open the publisher's page for the full experience

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