Change cells to list the number not the formula (97SR1)

Topic

New Reply

If I have a column of cells that contain formulas, how would I change the cells to contain only the results of the formula and no longer the formula. I only want the result in the cell.

Reply | Quote

Replies

Do the following:

1- Select the cells that contain the formula, or the whole column.

2- From the Edit menu click on Copy.

3- From the Edit menu click on Paste Special.

4- In the top section of the dialog box labeled Paste, click on the radio button next to Values.

5- Click the OK button.

The cells should now be replaced with the values.

Reply | Quote

1/ Select the cells
2/ Copy the cells
3/ Right click on the first cell and select paste special
4/ In the options that come up select values

Reply | Quote

Thank you! Works great.

Reply | Quote

I would highlite the range of cells containing your formulas, copy them and paste them over the highlited range with Edit>PasteSpecial>Values.
You are left with numbers only, all formulas are gone

Reply | Quote

That’s the way I do it, too, Manfred. It saves a few extra steps.

Reply | Quote

This is a TIP.

Make Excel formulas permanent with your mouse (95/97/2000)

One of the tasks that users commonly perform in Excel is converting
formula results to fixed values. To do this, you probably copy the
formula and then use the Paste Special dialog box to paste the
permanent values over the original formulas. However, there’s a much
easier way that doesn’t require any trips to the menu bar or Paste
Special dialog box. First, select the range of formulas you want to
convert. Then, using the right mouse button, drag the selected range
one cell in any direction, and then return the range to its original
location. When you release the mouse button, Excel displays a
shortcut menu. Simply select Copy Here As Values Only (Copy Values
in 95) to make the formula results permanent.

Reply | Quote

Hi Servando,
You can also use a one line macro:
selection.formula = selection.value
I have this assigned to a menu item on the right-click shortcut menu for ease of use.

Reply | Quote