I have been asked a Calc question to which my immediate thought was to reply: "No, that is not the way spreadsheets work". On reflection, I began to wonder if the following was possible.

Cell A1=1 cell B1=2 cell C1=A1+B1 The result "3" is displayed in C1
The question: "Other than over-typing the function in C1 with a number value, is it possible to convert the result into a permanent value, which would allow the contents of A1 and/or B1 to be deleted?"

I don't know why the user wants to do this and I don't much care. It's more a case of satisfying my own curiosity.

Any thoughts?

Dave

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to