zeros
 

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

"heritage" wrote:

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!

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

"heritage" wrote in message
...
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!

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

"CarlosAntenna" wrote in message
...
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

"heritage" wrote in message
...
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!