=H2&" "&I2&" Units"&" (Ave £"&ROUND(K2,1)&" )"


Regards


Peo Sjoblom

"gb_S49" wrote:

I am using the following to consolodate the cell contents into one cell for a
chart label. My problem is
H2 data is numeric (no prob)
K2 is currency (£) and is displayed to the enth degree. is there a way to
round the information to say 1 decimal point
=H2&" "&I2&" Units"&" (Ave £"&K2&" )"