Try using conditional formatting by setting the font color to the background
color?

--
Cheers
Nigel



"John" wrote in message
...
Dear all,

How can I format a cell when the cell value is zero,display it as space

Thanks you