Hide zero values in sum fields

Question

How do I hide/suppress zero values in sum fields so that nothing is displayed unless it is greater than zero?  I recall in a previous version of Excel it could be done by a global worksheet setting but do not see it now in Office 2016.  Am looking for an approach that will work in Office 2016 for Windows and, preferably, also in Excel for Mac.

Answer 1

Hello Dan,

You may hide the zero value in Excel on Windows using the information mentioned in the following Microsoft article and check if it helps.

https://support.office.com/en-us/article/Hide-or-display-zero-values-6FF815CA-E075-4F0B-ADBE-728E1559B404

For better suggestion for the query related to Excel on Mac, you may post your query in below mentioned forum link.

http://answers.microsoft.com/en-us/mac/forum/macoffice2016

Hope the information helps. Do reply if you need further assistance, we will be happy to help you.

Thank you.