Cell Shows 0.00 but still has a number

G

Guest

I have a formula in a cell that calculates a range of cells. The cell that
contains the formula shows 0.00 after it factors in all of the numbers. The
problem is that the number in the cell is not really 0.00. If you expand the
number of decimal places to 12 it will show as 0.000000365214. This shows
even if you manually calculate all of the numbers and the answer is 0.00. I
have tried to copy the formula from another cell where this does not occure
but end up with the same results. I am trying to do a conditional format
that highlight cells that equal 0.00. With this happening the formatting is
not working because the answer is not 0.00. Any help to correct this would
be great.
 

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

3 numbers in each cell aligned verticaly one number in each cell 1
I am trying to use the IF and SUMIF function on Excel 8
Excel 2002: How to find 0.00 in a column of number? 4
Cell formulas 2
Number format 1
ZERO VALUE NOT WORKING 2
How do I format a cell in Excel to show a dash instead of 0.00? 2
Prevent formula from changing when adding in cells 2

Top