decimal places in format cell
 

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.

decimal places in format cell
 

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.

decimal places in format cell
 

that work thanks

"kassie" wrote:

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.