If you really want to hide #DIV/0, you can do it using Conditional
formatting. It'll still be there, but you won't be able to see it.

Select the cell/s of interest.
FORMAT - CONDITIONAL FORMATTING
Formula is (select the cell that is the divisor) and type =0. (it should
look like this = =$A$2=0)
Then format the font color for the text to WHITE (or whatever the background
color is).

If you select multiple rows and/or columns, you may need to remove some or
all of the $ from the formula to get it to work.




"jeffc4442" wrote in message
...
I've reviewed some of the answers to this issue in this forum, but they
confuse me. I am a complete rookie with excel. From the help file, i was
instructed to select the cell, go to format/cell/protection, and click
hide
cell, etc. I protected the sheet, but the formula was still visible.

First, why doesn't this work?
Second, how do i hide #DIV/0! where the cell formula is =SUM(C13/C4).

thanks.