View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sousixer Sousixer is offline
external usenet poster
 
Posts: 5
Default Why are there inconsistencies in the display of zeroes in account.

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.