Value does not display in cell

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

I went in and checked zero values. The prob;em with the
that is that it puts zeros in every cell of the worksheet
that is blank.
 
TJ said:
I went in and checked zero values. The prob;em with the
that is that it puts zeros in every cell of the worksheet
that is blank.
Click to expand...

No, I don't think you will ever see anything in a BLANK cell! You will
certainly see 0 in any cell with a formula that evaluates to zero. You have
to decide whether or not you want to see any zeros. If you do, you must have
"view zero values" checked. Then, to get rid of those you don't want to see,
you would need to modify the formulas, for example:
=IF(YourFormula<0.005,"",YourFormula)
 

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

Linking sheets how do I display the zeros (0) as blank cells 1
NumberFormat for small non-zero numbers? 2
formula result is zero but zero is not populating in cell 3
Random #VALUE! error in simple SUM formula results 3
Blank Cells vs. Zero Values 2
Identifying the # of cells containing data 3
How does a function provide a blank cell as a result 2
TRANSPOSE results in zero values for blank cells 2

Back
Top