Try this

="Average "&ROUND(AVERAGE(D:D),2)


"gb_S49" wrote in message
...
I have entered the following in cell A1 ="Average "&AVERAGE(D:D)
and the value I get is Average 47.247619047619.
How can I round down to 1 decimal place?
I have tried number format but it does not make a difference
:-(