Excel: Deleting Formulas from Cells Without Losing Values

• Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0, 5.0
• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

In Microsoft Excel, to remove a formula from a cell without losing the resulting value in that cell, do the following:

1. Select the cell (or range of cells).



2. From the Edit menu, choose Copy.



3. From the Edit menu, choose Paste Special.



4. Select Values. Click OK.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20 3.0 replace

Keywords :
Version :
Platform :
Issue type :