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