Steve, just us the IS function.

If you want to your final worksheet to mirror exactly your input
worksheet, use =IF(ISBLANK(inputworksheetA1," ",inputworksheetA1).

Final worksheet will no longer reflect zeros whenever your input
worksheet is blank.


DangerMouse wrote:
I dont wish to hi-jack this thread, but might I ask how you accomplished
the displaying of blank cells as blanks in a linked workbook?

thanks

steve


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=552656