Are you using AVERAGE() or a formula you created to do the average?

Maybe the precission you chose to display is too small. i.e. if you have a
cell formatted to show no decimal places a number like .15 will be rounded to
0. Try increasing precision: Format-Cells-'Number' tab

--
Regards,
Dave


"Thennessee" wrote:

I have a simple averaging formula in an excel spreadsheet that is now
providing nothing but a zero as a result of the formula. I have ensured that
the cell format is for "Number" and that all of the cells for the formula are
formatted for "number" as well. I am not getting the "DIV/0!" error so I know
it is not a dividing by zero error.