Amazing!
First, you are so quick!
Then, you guys are almost too good.
Thank you!
John Gilchrist
----- Original Message -----
From: "Bob Long" <[EMAIL PROTECTED]>
To: <users@openoffice.org>
Sent: Sunday, October 21, 2007 1:02 AM
Subject: [users] Re: Please. How do I format in Calc?
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]
--
No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.488 / Virus Database:
269.15.3/1082 - Release Date: 10/20/2007 2:59 PM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
