Maybe

="Average "&TEXT(AVERAGE(D:D),"0.00")

Mike

"gb_S49" wrote:

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
:-(