Hi,
that happens because you have formulas that came from calculations where you
have more than 2 decimals, let say one calculation is 0.0002 - 0.000000002
a work around is to add an if statement to the formula like
=IF(+F4-F5>0.001,"",F4-F5)
in that way will fill the cell with a blank
if this helps please click yes, thanks
"TH52" wrote:
> I have a spreadsheet where I am trying to sum a column of 2 digit decimal
> numbers. When it is summed, I get (0.00). Expanding out the decimals of the
> sum field, I am finding numbers in the 10th digit to the right of the
> decimal. This sum field is defines as only 2 digit decimal like the rest of
> the numbers. Why would excel do this?
|
