Re: formulas ->values?



On Sat, Jan 05, 2002 at 01:10:02AM -0300, German Poo Caaman~o wrote:
El vie, 04-01-2002 a las 23:25, Alexander Kirillov escribi?:
can anyone tell me if there is a simple way to replace formulas by their
values? I know that one can copy the cells to clipboard, then use
"Edit->Paste Special->as values", then remove the original cells. Is
there a shorter way?

May be expression(@cell).  It's not the same as you're asking, but
it can to show the formula "as is" in another cell.

That has a completely different.  He is looking to store just the
values of the cells, and remove the expressions that generate them.
The technique you mention displays the expressions and hides the
values.  You can achieve the same effect more simply using
    Sheet -> Format -> Display Formulas (Ctrl-`)



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]