Decimal Place Problem

mbgramma · May 3, 2004

I have a value in a cell (the result of a formula) that should be 0.00
but it's not.

The problem is in the decimal places. Everything looks good until
get to the 11th decimal place and then I see a number.

This is happening in more than one cell. Any suggestions?

Thanks in advance

Dave R. · May 3, 2004

Here is some reading;

http://www.cpearson.com/excel/rounding.htm

If you want 0.00 in that case, you can round it to 2 decimal places by
wrapping =ROUND(formula,2) around your formula.

Decimal Place Problem

mbgramma

Dave R.