Hide zeros or replace them in Excel cells or pivots and graphs

Original by Reinie, 2017

This summary note was posted on 18 February 2017, by Reinie in Excel

Change the format of the cell to personalised format to the following:
(might be other ways of course but this works… feel free to comment..oh wait you cant.. 😉 )

For numbers
_ * ###0_ ;_ * -###0_ ;_ * “NA”_ ;_ @_
(replace NA by any value or just nothing)

For percentages
_ * ###0%;_ * -###0% ;_ * “NA”_ ;_ @_
(replace NA by any value or just nothing)

Tweak according to needs…

Latest Hamster Notes

Start with Why posted in Management #innovation, #Why
4 steps to optimise product value posted in Agile Management #agile, #product, #Scrum, #value
5 paradoxes of digital business leadership posted in Agile #agile, #leadership, #value
Product Vision, 10 tips posted in Agile #agile, #product, #Scrum
Progress in adopting the Principles for effective risk data aggregation and risk reporting 2023 posted in Credit risk Finance #BIS, #data, #reporting
Leadership styles by ChatGPT posted in Management #ChatGPT, #leadership, #style
Gen AI round table posted in Machine Learning #ChatGPT, #Copilot, #Gen AI, #Github
Leadership in fully remote teams posted in Management #leader, #leadership, #remote, #thatconference19
Leadership for the reluctant leader posted in Management #leader, #leadership, #thatconference19
Corporate Credit Risk Modelling and the Macroeconomy posted in Finance #corporate, #duration, #macroeconomy