Microsoft KB Archive/68251

Works: Converting a Formula or Function Cell to a Value

PSS ID Number: Q68251 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbotherspreadsheet database

= SUMMARY =

There are two ways to convert formulas or functions to values. You can convert either one cell at a time or a selected group of cells all at once.

To convert one cell at a time:


 * 1) Place the cursor over the cell containing the number produced by a formula or function.
 * 2) Press F2 (Edit), then press F9 (Calculate Now).
 * 3) The formula or function in the selected cell will be replaced by the value.

To convert a selected group of cells:


 * 1) Select the group of cells to convert (position the cursor on the upper left corner of the cell group and press F8; use the direction keys to highlight the area).
 * 2) From the Edit menu, choose Copy Special.
 * 3) Press ENTER.
 * 4) In the option box, select “Values only.”

The selected area will be converted to values only.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.