decimal places in format cell

[tom]

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.

 

[kassie]

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

 

[tom]

that work thanks

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