zeros show as dashes in spreadsheet, want to show 0.

[emilyann]

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.

 

[Marcelo]

format as currency
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"emilyann" escreveu:

 

[Bob Umlas]

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"??_);_(@_)