Try

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"lovemark"
wrote in
message
...

I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in
cell a1 of
sheet 1, that number appears in sheet 2. The problem is that
when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually
zero.


--
lovemark
------------------------------------------------------------------------
lovemark's Profile:
http://www.excelforum.com/member.php...o&userid=34611
View this thread:
http://www.excelforum.com/showthread...hreadid=543836