decimal places in format cell

[Guest]

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.

 

[Guest]

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

 

[Guest]

that work thanks

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