At 14:04 05/11/2008 +0000, John M Collins wrote:
Is there a way, in Calc, where a cell has a formula, of replacing
its contents with whatever is currently being displayed so it's just a number?
Yes.
o Copy the cell.
o Paste what you have copied back into the 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 Formulas is *not* ticked (and other
appropriate options are).
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
