Kevin Vaughn thanks for your reply. This issue has been driving me
crazy. This does solve my problem for the most part however using
INDIRECT has caused another problem. On several of the cells I do not
want a 0 to appear where a value is not detailed. I have tried the
following but it still shows a zero.

=INDIRECT(IF("sheet2!a1"<0.001," ","sheet2!a1")). Any idea how I get
around this problem?

Thanks again.


--
MDW
------------------------------------------------------------------------
MDW's Profile: http://www.excelforum.com/member.php...o&userid=32769
View this thread: http://www.excelforum.com/showthread...hreadid=526018