Stephanie,

Use Tools | Options.... Calculation tab, check "Precision as displayed"

HTH,
Bernie
MS Excel MVP


"Stephanie DeCou" <Stephanie wrote in
message ...
I saw a post that asked this question and the guy who answered made him
look
stupid but I agree with the man.

I use Excel to do accounting work. What happens is the numbers add as the
original number and not the rounded number. That can lead to some serious
miscalculations.

Is there a formula that can be used when multiplying or dividing that will
round the number to the nearest hundredth and have the column properly add
the rounded numbers? The way it is right now, it adds the whole number
not
the rounded.

I think the IRS might have something to say if the pennies start adding up
to $100s of dollars in missed tax monies.