="Avg "&TEXT(D30,"0.00")
--
David Biddulph


"David" wrote:

When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as
Avg 0.286253661284266 but I only want it to 2 decimal points!

The D30 cell contains the simple formula for £152458.70 divided by 532,600

Can someone explain or show me how I can produce an answer to 2 decimal
points as "Avg 0.28"?

Thanks