Microsoft KB Archive/22822

{|
 * width="100%"|

Excel: Deleting Formulas from Cells Without Losing Values

 * }

-

The information in this article applies to:


 * 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 :

Technology :