how to display zero as dashes in worksheet

[hbee]

how to display zero as dashes in worksheet?

 

[JE McGimpsey]

One way:

Format/Cell/Number/Custom: General;General;"-";@

 

[Gord Dibben]

Format>Cells>Number>Accounting with Symbol set to "none".


Gord Dibben MS Excel MVP