Good morning Eamon

I was just going to answer this, but notice you've just got a reply.

An alternative would be to got to Tools Options, View, and then
uncheck zero values. This would suppress zeros across your whole
workbook.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=376241