What is your cell format and formula? What does =ISNUMBER(cell) return when
cell points to each input and the cell with the formula? If it returns
FALSE, what does =LEN(cell) return?

Your reported results taken at face value appear to rule out the obvious
problems, but =2/7 in Excel returns 0.285714, which when rounded to 3 decimal
places is 0.286. If you want 0.285, you probably intend
=ROUNDDOWN(2/7,3)

Jerry

"Kenosha" wrote:

Thanks. That solved the decimal problem. I still can not get 2 divided by 7
to be more than an integer and be .285 rather than .000.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.