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

  • Thread starter Thread starter emilyann
  • Start date Start date
E

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.
 
format as currency
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"emilyann" escreveu:
 
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"??_);_(@_)
 
Back
Top