Microsoft KB Archive/93355

= Works: Replacing a Formula with a Constant in Spreadsheet =

Article ID: 93355

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q93355



SUMMARY
In the spreadsheet module of Microsoft Works for Windows, a formula can be replaced with its numeric result using the following procedure:


 * 1) Select the range of cells containing the formulas to be replaced.
 * 2) From the Edit menu, click Copy.
 * 3) Leaving the area highlighted, click Paste Special from the Edit menu.
 * 4) In the Paste Special dialog box, select Values Only and click OK.

The selected area will now contain only numbers and no formulas.



MORE INFORMATION
For example, if cell C10 contained the formula =A10+B10, and cells A10 and B10 10 and 20 respectively, the value of C10 would change whenever A10 or B10 was changed. However, using the Paste Special command and the method above, the contents of cell C10 would be made a constant 30.

