Forgive me I'm new to this, is that an addition formula you gave me for A1
and A2? Please advise.



"Damon Longworth" wrote:

Excel is only rounding the appearance and not the value. You will need to
use one of the Round functions.

Try:

=round(a1,2)

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Joe Tahoe" <Joe wrote in message
...
The Excel program does a good job at rounding off numbers and applying
decimal points, however, the residual value is still present when
multiplication or summation is applied. In other words, the cell will
show
2.33, but behind the scenes it still has a value of 2.32957, therefore
when
multiplying this cell with another, the value used will be 2.32957 and not
2.33. As a result, my Excel totals are different than my Quick Books
totals.
Any help will be appreciated. Thank You.