John Gilchrist wrote:
> Here is the expression I am using:
> =CONCATENATE("K=1/n= ";'Daily Summary'.M6)
>
> Here is the result I get:
> K=1/n= .117924528301887
>
>
> Here is the result that I want:
> K=1/n= 11.79%
>
> 1. How do I format this in Calc?
>
> 2. Also, how can I begin to use a format code notation ##.## which I
> found in the help file?
> I cannot find any help file example.
I'm not sure if this meets your requirements, but you may be able to do what
you want without the concatenation.
That is, simply format the cell with a custom format. That is, if your cell
contains, say, the value 0.117924528301887, do this:
Right click on the cell|Format cells|Numbers. Highlight "User defined" in
the list; enter:
"K=1/n= "0.00%
into the "Format code" field, and click the green tick and OK. The cell
should then show as:
K=1/n= 11.79%
Once you've done that, that format is available to format other similar
cells.
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
