[Solved] Convert formula to value

[rogerknightOO]

In Excel, Edit/Paste special allows a formula on clipboard to be converted to its value.

As a new OO user, I cannot find out how to do this, despite spending much time with the help system.

[acknak]

For a single cell, press F2, then F9 to see the result of the formula. Press Enter at that point to replace the formula with the calculated result.

For multiple cells, or if you want the result in some other location, copy the formula cells to the clipboard, then Edit > Paste Special. Un-check "Paste All" and then "Formulas" (and any other properties you don't want to carry over), then OK.

[mriosv]

If you press and hold the paste button, there is several options, one Unformatted text. That do the trick.

[tlotman]

Is there a way to get the data automatically placed in another column without manually doing a "paste special".
Would you have to write Visual Basic command to write the results of the formula from column C over to D?

See the attached.

[Zizi64]

Would you have to write Visual Basic command to write the results of the formula from column C over to D?

Yes you can write a macro for this tast, but not in Visual basic.
Use the built-in StarBasic IDE and the API functions/procedures.