If your formula results in more than 2 decimals, use =ROUND(<your formula,2)
--
Hth

Kassie Kasselman


"tom" wrote:

I set my decimal place to 2 places in both the worksheet setup and format the
cells. but when I enter data into the worksheet there is a formula I enter
that calculates an answer with many places past the decimal.