blank cells

[Mike]

how can i stop excell putting ## in a cell when the cell
it is looking at is blank

 

[Frank Kabel]

Hi
could you post yor used formula