number formatting

[RDL]

Hi,

I am using this formula: =AVERAGE(S3:S372) to get the
average number of months that patients waited for a new
doctor. The answer is 6.26 when I format the cell number
at two decimal places. However, when I use the formula
=AVERAGE(S3:S372)," months" the answer changes to
6.260869543 months. How do I get it to read 6.26 months,
without the huge decimal change?


Thanks in advance!

 

[Don Guillett]

round
int
format(average etc

 

[Frank Kabel]

Hi
some ways:
=TEXT(AVERAGE(S3:S372),"0.00") & " months"

or
=ROUND(AVERAGE(S3:S372),2) & " months"

 

[Guest]

Frank, Thanks for all your help. You are a lifesaver!