I don't know why you can still see the formula. If you protect
the sheet, cells with "hidden" formulas will not display the
formula. It works fine for me.
There is no way through formatting to hide error values. Instead,
you should write your formula in such as way that the error will
not occur in the first place. E.g.,
=IF(C4=0,"",C13/C4)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"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.