At 00:23 21/10/2007 -0500, John Gilchrist wrote:
Here is the expression I am using:
=CONCATENATE("K=1/n= ";
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.
To answer your second question first, you can use the format codes in
the "Format code" box on the Numbers tab of the Format Cells
dialogue. But you can also use them in the TEXT function, which
allows you to convert a number explicitly to a text string.
In fact, the answer you are getting here is right, of course: 0.1179
*is* 11.79%: it's just not formatted as you wish. You may be getting
confused by the fact that if you want a percentage displayed in a
number cell, you do it by formatting the cell. This means that if
you see "11.79%" in your cell M6 (and if you've arranged this the
normal way by applying a percent format to the cell), what is
actually there is still .1179... . To get the actual percentage
displayed, we have to multiply this number by 100, of course.
Try this:
=CONCATENATE("K=1/n= ";TEXT('Daily Summary'.M6*100;"##.##");"%")
If you want a consistent number of fractional places, even where they
may be zeroes, you may prefer to use a format such as "##.00". And
note that the "&" operator is a generally easier alternative to the
CONCATENATE function for expressing concatenations. So you may want
to try something like:
="K=1/n= "&TEXT('Daily Summary'.M6*100;"##.00")&"%"
Another way to approach this is to put all the accompanying text into
the cell format instead of into the cell as text. To do this, put:
='Daily Summary'.M6
into the cell itself, so you just have the original value there (a number), and
"K=1/n= "##.00%
into the "Format code" box on the Numbers tab of the Format Cells dialogue.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
