Hi Bart,
You want to do the reverse. Enter the formula that you want in A2. In A1
enter:
=formula(A2)
This is what you'll get:
A
1 =(2*2)+4
2 8
I don't know if there is a function that will let you build a formula
from a text source.
tc
Bart Aimar wrote:
hi all,
simple question:
In cell A1 a count in string format: (2*2)+4 (x examp.)
I would see the result in cell A2 (8)
But, if in A2 I write: ="="&A1
the cell return: (2*2)+4
The same result using: =Concatenate("=";A1)
Any idea to force Calc to calculate the formula?
Thanks in advanced
Bart
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
