Excel: Getting the Numeric Presentation That You Want
Are there are times that you want to display values a certain way – but just can’t seem to find the right format? Excel allows you to customize your numeric values any way you want. For this example – we’re going to choose the CURRENCY format…then customize it so that zero values as as zero (instead of the default dash).
Full tip: Excel tip