# How to copy and paste only data from the spread sheet ? [closed]

If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.

First time here? Check out the FAQ!

How to copy and paste only data from the spread sheet ? [closed]

If cell A2 contains =(2+2). After pasting I want cell as 4 hard coded instead of formula.

close date 2015-11-12 03:52:27.473172

3

Press **F2-F9-Enter-Enter**

or

**Ctrl+C**, right click an choose **Paste Only-Number**

or

**Ctrl+C, Ctrl+Shift+V** (Edit - Paste Special)

F2 (Edit mode), F9 (Recalculate formula to value), first Enter - insert result of recalculation to cell, second Enter - finish edit cell

@Pedro 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)

Asked: ** 2013-10-18 12:15:05 +0100 **

Seen: **24,250 times**

Last updated: **Oct 19 '13**

Paste special with custom delimiter [closed]

dde links to writer from calc [closed]

Print output cut off - legal vs letter [closed]

Failure of: soffice.exe -headless -convert-to on windows [closed]

Calc: Sum only numbers entered manually (where ISFORMULA returns FALSE)?

Inserting percentage symbol [closed]

Opening ODS file very slow. [closed]

incorrect property value in vba macros

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

How is this question invalid? I just came here for exactly the same reason as the OP.

For a similar question, see question 59306.