how to display zero as dashes in worksheet

G

Gord Dibben

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
zeros show as dashes in spreadsheet, want to show 0. 2
Need to change numbers with dashes to numbers with no dashes 3
Formatting zeros as dashes 4
Formatting Worksheets 2
Zero Formatting 1
How to correct a #N/A in vlookup 1
Removing Dashes 2

Top