If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.
How is this question invalid? I just came here for exactly the same reason as the OP.
For a similar question, see question 59306.
Ctrl+C, right click an choose Paste Only-Number
Ctrl+C, Ctrl+Shift+V (Edit - Paste Special)
@JohnSUN, what is “F2-F9-Enter-Enter” supposed to do? It doesn’t work in LO 4.1.3 under Windows XP
Thanks for the Paste Only > Number. I had never noticed that and it is VERY useful!
F2 (Edit mode), F9 (Recalculate formula to value), first Enter - insert result of recalculation to cell, second Enter - finish edit cell
@Pedro1 I meant that there is a quick and easy way to replace the formula in the cell at the result. For example, after the usual copy-paste (Ctrl+C - Ctrl+V) you get a formula in a cell . And then press the four buttons and the formula changed to just a number (or text, or date)
@JohnSUN - this is indeed a nice way for single cells! Thanks!
@JohnSUN, I see now what you mean. Thank you for the explanation and for the animated GIF