Tip #186_Excel

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