Get rid of the zeros?!

[mevetts]

Hi,

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

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

Many thanks,

Mark

 

[Niek Otten]

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

 

[Dave Peterson]

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

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.

 

[Nick Hodge]

Mark

You need to wrap it in an IF function

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

or Tools>Options...>View and uncheck 'zero values'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]

 

[mevetts]

Fantastic, thanks for the help

 

[Ashish Mathur]

Hi,

You may use conditional formatting on the Format toolbar.

Regards,