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



"emilyann" escreveu:

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.