Hide Negative Numbers In Excel Pivot Table

Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the http://www.howtoexcelatexcel.com blog for lots of #exceltips Join thousands of other Excel users who have already joined the Excel At Excel Monthly Newsletter. 3 FREE Excel Tips every month. http://www.howtoexcelatexcel.com/newsletter-sign-up/ Be Social & Let's Connect ++Website http://www.howtoexcelatexcel.com ++Twitter https://twitter.com/howtoexcelatex ++Pinterest http://www.pinterest.com/howtoexcelat #exceltips #exceltipsandtricks #exceltutorial #exceltipsandtricks Hello Excellers, I have a handy Excel Pivot Table Tip for you today. I was creating a Pivot Table this week, (one of many!), and it contained negative numbers. Now, this was not the end of the world, but I really only wanted positive numbers to show in my Pivot Table. I did not want either of the zeros or the negative numbers to be visible. This is a handy little Excel trick, so I thought I would share it with you. We can use cell formatting to hide both of the negative and zero numbers. -Click on the Sum of Stock Balance field