Brian Barker wrote:
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
A related, but different issue.
Col A is a calculated column. I want to copy the *value* of that to Col
B so that when I delete Col A I do not get an error.
How ?
Thanks
--
Bill Drescher
william {at} TechServSys {dot} com
