On Thu, 8 May 2008 12:38:11 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

If you want to physically round the value to one decimal place (that is,
reduce its accuracy), then you have your answer in the other postings in
this thread. However, if you only want to display it to one decimal place,
but keep its full accuracy (perhaps for other calculations), then leave keep
your formula but Custom Format the cell (right click the cell and select
Format Cells) using 0.0 as the pattern.

Rick

I don't believe that will work since his formula is a concatenation of strings.

However, if he changed his formula to :

=AVERAGE(D:D)

And then used the Custom Format:

"Average "0.0

the result would be as he might want.
--ron