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


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.
 
Ad

Advertisements

M

Marcelo

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



"emilyann" escreveu:
 
Ad

Advertisements

B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top