Replace formula with value automatically.

[datakman]

Looking to find a way to replace a formula with its value after the value is
determined. Would prefer not to go into COPY+PASTE+VALUE to make this
happen. Is there a command or string that will make this happen?

 

[Bernard Liengme]

Yes, the command is COPY+PASTE+VALUE
Short cut method: CTRL+C; ALT+E, the S and then V
Have you experimented using right click to do this.

Bob Umlas has a way of dragging to right and back to left that does the
COPY+PASTE+VALUE but I cannot recall it. But Debra has instructions
http://blog.contextures.com/archives/2009/02/04/paste-values-shortcut-for-excel/

best wishes

 

[Shane Devenshire]

Hi,

Not really anything that does exactly what you want, but here are three
options:

1. Select the formula on the Formula Bar and press F9, Enter
2. Select the cell directly below the formula and press Ctrl+" (control
double quotes)
3. Use a macro

Sub ConvertToValues()
Selection = Selection.Value
End Sub

 

[datakman]

You have to excuse me. This is the first time I have used this type of help.
As you can see, I submitted the question twice. I couldn't find this
location so I didn't know where the question went to.

I know how the work the CTR+C, CTR+V. Didn't know about ALT+E.

What I want to accomplish is through an IF statement:
If a cell has a number in it, say anything >0, replace the formula cell with
the calculated value or leave as is.

 

[Bernard Liengme]

A formula cannot alter what is in a cell
Only a VBA subroutine can do this