David,

Hide the error with
=IF(ISERROR(A1/B1),0,A1/B1)

Miek


"David" wrote:

Q1) How do i get a cell to show/display zero when no data has been input or
when the dat has been deleted.

Q2)how do i get a cell to display 0 instead of #DIV/0!