Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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&" )" |
#2
|
|||
|
|||
=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&" )" |
#3
|
|||
|
|||
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&" )" |
#4
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |