Currency in cell ref

G

gb_S49

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

Josh

try the text function:

=H2&" "&I2&" Units"&" (Ave "&TEXT(K2,"£0.0")&")"

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
count cell if value present in every other cell + criteria 2
SumProduct not Working in a Macro 6
Month & year question 4
Sum At Top And Move Cells Down in VBA 3
count if equal to not working? 1
How to break apart a Decimal formatted number? 2
Value Rounded when copied from another cell 3

Top