Blank result cell instead of zero

R

Rich D

In Excel 2003, I have identical formulae in defferent worksheets. In one
worksheet if there is no result, it shows a zero. In the other worksheet,
the cell is blank. I think there is a switch someplace to show zero or blank
but I don't know where it is. How can I make that choice? I don't
understand how the two different worksheets got set different. 1 was a copy
of the other...does that have something to do with it?

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula returning a blank cell if answer is zero 7
Form calculations. 5
formula result is zero but zero is not populating in cell 3
Convert zero-length string or blank cell to null 3
display zero for blank records on report 5
Linking sheets how do I display the zeros (0) as blank cells 1
BLANK CELLS 2
How does a function provide a blank cell as a result 2

Top