Formula to Value

Topic

New Reply

I have to convert formula’s to actual values, I do this by pressing F2 then F9, unfortunatley I can only do one cell at a time. ( or does someone know different),

I am using Excel Office 97 SR2b

Reply | Quote

Replies

have you tried to Copy then Edit>Paste Special>Values?

Mark

Reply | Quote

Thanks to all who replied, It works fine
Braddy60

Reply | Quote

I do this so often I have a macro on a button to do Copy & Paste Special/ValuesOnly in one hit:

Sub ReplaceWithValues()
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = True
End Sub

Reply | Quote

Select all of the cells that you want to convert, and the select Copy from the Edit menu. With the same cells still selected, select “Paste Special” from the Edit menu. In the dialog box, click on “Values” in the “Paste” section, then click on OK. All of the cells should be converted to values.

Reply | Quote

You might want to put the “Paste Values” Icon on your toolbar. I use it a lot.

Reply | Quote