Sousixer,

To change a '0' to '-'. Highlight all of the cells you wish to format and
then go to Format cells (by right-clicking or Ctrl+1 or Format | Cells).
Select the Accounting category in the left side of the window. On the right
side, in the Symbol dropdown menu, choose None.

HTH.

"Sousixer" wrote:

As a CPA, I often use the accounting format with no dollar sign. Sometimes a
cell which contains a formula resulting in zero will show the zero as -
(which I prefer). Other times the zero will be shown as 0.00 or even (0.00).
Why the differences and how do I make it always show a zero as - ?

Thanks in advance for anyone's help.