One way:

=IF(Sheet1!A1<"",Sheet1!A1,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"statusquo" wrote
in message ...

Hi,

This is really annoying, but whenever I make a reference to a blank
cell, it turns into a zero, not a blank cell. Is there any easy way to
fix this?

Thanks


--
statusquo
------------------------------------------------------------------------
statusquo's Profile:
http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931