Accounting format is _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
so the 0 part is the _($* "-"??_)
You can substitute 0 in this part & make it line up with everything else by
using this format:
_($* #,##0.00_);_($* (#,##0.00);_(* "0"??_);_(@_)


"emilyann" wrote in message
...
My cells are formatted as Accounting. In "Tools, Options, View, Display
all
zero values" is checked. I do not have any custom formulas in my cells to
return a dash when the value is zero. Yet 99% of the zero values are
showing
as dashes, with one showing as a zero, and one as (0). How can I show the
numeral zero instead of dashes? Thank you.