software

Hi,

I have got two worksheets and have set-up some simple formulas that
just copy whatever is typed into a cell on the first sheet into the
same cell onthe second sheet. e.g. =Registers!B58

However, if nothing is typed into the cell then a pesky 0 appears on
the second sheet. Is there anyway of preventing this?

Many thanks,

Mark.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494651=IF(Sheet1!A1=quot;quot;,quot;quot;,Sheet1!A1)

--
Kind regards,

Niek Otten

quot;mevettsquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have got two worksheets and have set-up some simple formulas that
gt; just copy whatever is typed into a cell on the first sheet into the
gt; same cell onthe second sheet. e.g. =Registers!B58
gt;
gt; However, if nothing is typed into the cell then a pesky 0 appears on
gt; the second sheet. Is there anyway of preventing this?
gt;
gt; Many thanks,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=494651
gt;
=if(Registers!B58=quot;quot;,quot;quot;,Registers!B58)
mevetts wrote:
gt;
gt; Hi,
gt;
gt; I have got two worksheets and have set-up some simple formulas that
gt; just copy whatever is typed into a cell on the first sheet into the
gt; same cell onthe second sheet. e.g. =Registers!B58
gt;
gt; However, if nothing is typed into the cell then a pesky 0 appears on
gt; the second sheet. Is there anyway of preventing this?
gt;
gt; Many thanks,
gt;
gt; Mark.
gt;
gt; --
gt; mevetts
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=494651

--

Dave Peterson

Mark

You need to wrap it in an IF function

=IF(Registers!B58=quot;quot;,quot;quot;,Registers!B58)

or Toolsgt;Options...gt;View and uncheck 'zero values'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;mevettsquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have got two worksheets and have set-up some simple formulas that
gt; just copy whatever is typed into a cell on the first sheet into the
gt; same cell onthe second sheet. e.g. =Registers!B58
gt;
gt; However, if nothing is typed into the cell then a pesky 0 appears on
gt; the second sheet. Is there anyway of preventing this?
gt;
gt; Many thanks,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=494651
gt;

Fantastic, thanks for the help.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=494651Hi,

You may use conditional formatting on the Format toolbar.

Regards,

quot;mevettsquot; wrote:

gt;
gt; Hi,
gt;
gt; I have got two worksheets and have set-up some simple formulas that
gt; just copy whatever is typed into a cell on the first sheet into the
gt; same cell onthe second sheet. e.g. =Registers!B58
gt;
gt; However, if nothing is typed into the cell then a pesky 0 appears on
gt; the second sheet. Is there anyway of preventing this?
gt;
gt; Many thanks,
gt;
gt; Mark.
gt;
gt;
gt; --
gt; mevetts
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=494651
gt;
gt;