Get rid of the zeros?!
 

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: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651

Get rid of the zeros?!
 

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

--
Kind regards,

Niek Otten

"mevetts" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651

Get rid of the zeros?!
 

=if(Registers!B58="","",Registers!B58)



mevetts wrote:

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: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651

--

Dave Peterson

Get rid of the zeros?!
 

Mark

You need to wrap it in an IF function

=IF(Registers!B58="","",Registers!B58)

or ToolsOptions...View and uncheck 'zero values'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"mevetts" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651

Get rid of the zeros?!
 

Fantastic, thanks for the help.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651

Get rid of the zeros?!
 

Hi,

You may use conditional formatting on the Format toolbar.

Regards,

"mevetts" wrote:


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: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494651