I was asked by a client how I could display a dash (-) instead of 0 in cells. Although this could be done by the use of an IF statement, an easier way to do it is to select the cells to be adapted then go to the Format Cells Number tab (in Microsoft Excel 2007, 2010 and 2013, click on the dialog box launcher at the bottom of the Number group on the Home tab and in Microsoft Excel 2003 or earlier, click Format – Cells then go to the Number tab.)
Go to the Accounting section, then from the Symbol dropdown, click None.
Click OK. A dash will be displayed instead of a zero.
Find out more about our Microsoft Excel training Sydney, Australia.