Nellie said:
Excel 2003
I am selecting a column of 1 digit whole numbers to get the average total.
Instead of a "4" I get 4.1.1.1.
Do you mean you are getting several digits after the decimal
point? I don't know how you would get three decimal points.
I only want the "4".
Is this adjustable?
A couple of ways depending on your needs.
If you want only an integer in the cell, you can use the int function.
=int(average(<stuff>))
That will truncate anything after the decimal. If you need it to round
to the nearest integer, then you could do this.
=round(average(<stuff>),0)
If you only want it to *look* like an integer, you can change the
format so that it only shows the integer part.
Format > Cells > Number
then select the Number format, and set the number of decimal
places to zero. This will *show* the number rounded, but the value
in the cell will still be whatever Excel calculated, including
extra decimal places.
Socks
