At 22:12 15/06/2008 +1000, Dave Barton wrote:
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.
Tell the user that Paste Special is so often his or her friend!
o Select the cell and copy the contents.
o Paste the value straight back into the same cell, but using Edit |
Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V)
instead of ordinary Paste.
o In the Paste Special dialogue, remove the tick from "Paste all" if
necessary, and then ensure that Numbers (or whatever) is ticked but
Formulas is *not* ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
