Hi John
I may be able to help. It seems you just need the % after .M6
Cell M6 needs to be formatted as you say ##.##
This can be don by highlighting column M then go to Format>
CELLS>numbers>percent.
I hope someone can help me with my problem
Noranross
John Gilchrist wrote:
Dear OOo Users,
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.
Thank you,
John Gilchrist
Tulsa, OK
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.15.3/1082 - Release Date: 20/10/2007 14:59
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
