I can't find the "average" button on Microsoft Excel
F Fred Smith Feb 15, 2007 #2 It depends on what version you have. In 2002, it's in a drop down list beside the Sigma.
A Ashby Feb 15, 2007 #4 Either format the cell to "0.0" or use something like =ROUND(AVERAGE(A2:A5),1)