You can suppress zeros by going 'tools'....'options'...'view' tab and then
uncheck the zero values box. do you just not want to see the zeros or do you
actually want to put a blank into the cell?

"sarah" wrote:

If a cell value equals zero I want it to be blank. How would I word the
formula?