Currency in cell ref
 

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&" )"

=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&" )"

HERO
Thank you

"Peo Sjoblom" wrote:

=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&" )"

try the text function:

=3DH2&" "&I2&" Units"&" (Ave "&TEXT(K2,"=A30.0")&")"

You can adjust the decimal point and format of your number (i.e. 0.0,
0=2E00, 0,000.00, etc)