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

Original by Reinie, 2017Hamster_gagarin_linkedin
hamster writter This summary note was posted on 18 February 2017, by 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…