S Slash Registered User Messages 329 20 Oct 2005 #1 How do you display zero as a dash in Excel? Thanks in advance.
A avantarklu Registered User Messages 52 20 Oct 2005 #2 Format, Cells, General and #,##0.00;(#,##0.00);"-";_(@_)
B Brouhahaha Registered User Messages 184 20 Oct 2005 #4 If the cell is formatted as currency it'll automatically display a dash for zero. Only applies if it's currency you're dealing with obviously
If the cell is formatted as currency it'll automatically display a dash for zero. Only applies if it's currency you're dealing with obviously
A asdfg Registered User Messages 1,643 20 Oct 2005 #5 Also try Format, Cells, Accountancy, Change symbol to "None"