I don't want blank tp equal zero

Giganews Newsgroups
Subject: I don't want blank tp equal zero
Posted by:  lovemark (lovemark.282j5z_1148065202.3464@excelforum-nospam.com)
Date: Fri, 19 May 2006

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's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34611
View this thread:http://www.excelforum.com/showthread.php?threadid=543836