Episode 521 - Show Positives

Dermot sends in today’s question; a spreadsheet is showing zeroes as a dash, and positive numbers with a plus sign! It turns out that the custom number format has four zones, where you can specify different formatting for positive, negative, zero, and text values. Episode 521 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!