How can you best achieve this?
Choose an answer
Answer A In Tools / Options, choose Zeros as dashes on the View tab
Answer B In Tools / Options, enter a dash as the alternative zero character on the View tab
Answer C Use a number formatting code
Answer D Use an IF function to change any zero into a dash