Conrad
Again another post on a problem you already solved. I guess I had a difficult time understanding what it was you wanted to do and jumped to the wrong conclusion. Below is what Excel says for replacing a cells formula with the numerical results of the cell. I think as Clive pointed out it is just a matter of cut and paste but paste special (values only). Glad you solved the problem.
Replace formulas with their calculated values
When you replace formulas with their values, Microsoft Office Excel permanently removes the formulas. If you accidentally replace a formula with a value and want to restore the formula, click Undo immediately after you enter or paste the value.
1.Select the cell or range of cells that contains the formulas.
If the formula is an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.), select the range that contains the array formula.
How to select a range that contains the array formula
Click a cell in the array formula.On the Home tab, in the Editing group, click Find & Select, and then click Go To.Click Special.Click Current array.
2.Click Copy .
3.Click Paste .
4.Click the arrow next to Paste Options , and then click Values Only.
The following example shows a formula in cell D2 that multiplies cells A2, B2, and a discount derived from C2 to calculate an invoice amount for a sale. To copy the actual value instead of the formula from the cell to another worksheet or workbook, you can convert the formula in its cell to its value by doing the following:
1.Press F2 to edit the cell.
2.Press F9, and then press ENTER.
After you convert the cell from a formula to a value, the value appears as 1932.322 in the formula bar. Note that 1932.322 is the actual calculated value, and 1932.32 is the value displayed in the cell in a currency format.
Tip When you are editing a cell that contains a formula, you can press F9 to permanently replace the formula with its calculated value.
Larry G
