zeros

[heritage]

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!

 

[Frank Kabel]

Hi
maybe this number is actuially stored as 'Text'. What does the function
=ISNUMBER(Cell_reference)
return for this cell

 

[CarlosAntenna]

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

 

[CarlosAntenna]

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