zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to display zeros as dashes. It works in most cells but in some
cells, it keeps displaying (0) even though the formatting is copied to the
relevant cell. BTW, the formatting is set to Accounting.

Thanks in advance!
 
Hi
maybe this number is actuially stored as 'Text'. What does the function
=ISNUMBER(Cell_reference)
return for this cell
 
If the value in the cell is coming from a formula, it may be that the value
has more than two decimal places and rounds to zero. In this case a zero
will be displayed. If the cell is truly blank or zero it will display a
dash.

Carlos
 
There is a work-around for this. If you don't care abut losing precision,
you can set Tools > options > calculation > precision as displayed. Then
the zeros will become dashes, but it may affect the value of other
calculations that reference these cells.

Carlos
 
You must log in or register to reply here.

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

Similar Threads

Displaying zeros in cells 2
Calculation / Format Error 1
Adding recognised Zeros 5
my formated column is displaying one cell incorrectly 2
How to count the maximum number flanked by zeros 9
How do I insert hyperlinks in blank cells 6
NumberFormat for small non-zero numbers? 2
Handling Dashes in IF statement 3

Back
Top