RE: Currency in cell ref

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peo Sjoblom (PeoSjoblom_at_discussions.microsoft.com)
Date: 01/26/05

Next message: fofanna: "Is there a template for rapid debt repayment in Excel?"
Previous message: Peo Sjoblom: "RE: Is VLOOKUP the right function?"
In reply to: gb_S49: "Currency in cell ref"
Next in thread: gb_S49: "RE: Currency in cell ref"
Reply: gb_S49: "RE: Currency in cell ref"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 26 Jan 2005 07:05:04 -0800

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

Next message: fofanna: "Is there a template for rapid debt repayment in Excel?"
Previous message: Peo Sjoblom: "RE: Is VLOOKUP the right function?"
In reply to: gb_S49: "Currency in cell ref"
Next in thread: gb_S49: "RE: Currency in cell ref"
Reply: gb_S49: "RE: Currency in cell ref"
Messages sorted by: [ date ] [ thread ]