Hi timber. As you have had no replies so far from any Excell experts, I'll tell you how I acheive this result. I use conditional formatting (Format - Conditional Formatting) so that if the content of the cell is almost zero ( e.g. between .01 and -.01) the font colour is white. In this way the zero is still there, but invisible.