Microsoft KB Archive/31587

Multiplan: How to Copy a Value, Not the Formula PSS ID Number: Q31587 Article last modified on 10-08-1990 PSS database name: D_MPlan

3.x 4.00 4.01 4.2

MS-DOS

Summary:

If you copy a cell that contains a formula to another area of the spreadsheet in Microsoft Multiplan, please note that you are copying the formula in the cell, not the value that it currently returns. If the formula contains a relative reference, you can expect the value to change once the formula has been copied to another area of the spreadsheet.

More Information:

It is often desirable to copy only the current returned value of a cell, not the formula. One method for doing this is to first change the contents of the copied cell so that it contains only the value, before it is copied to some other cell. To quickly change the contents of the cell so that it contains only the value, do the following:


 * 1) Select the cell.
 * 2) Select the Edit command.
 * 3) Press the RECALC key (F4 on IBM compatibles).
 * 4) Press ENTER.

Another workaround for this problem is to write a macro and take advantage of the ’LE macro command, which performs the task of placing the returned value of one cell in another cell.

Copyright Microsoft Corporation 1990.