Although the OP probably meant the whole sheet another options would be to
use custom format like 0.00;-0.00; that way one can control where one wants
this done
--
Regards,

Peo Sjoblom

(No private emails please)


"Max" wrote in message
...
"KL" wrote:
...just a comment: the zero does not dissappear from the cell and the
cell
does NOT become "empty (clear of all contents)". They just become
invisible.

Correct, perhaps the line
Think zeros have been suppressed in the sheet ..

should have read as:
Think zeros display have been suppressed in the sheet

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----