# 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 +0200 **

Seen: **24,673 times**

Last updated: **Oct 19 '13**

paste text showing track changes

Is there a *.xlsx Filter Option? [closed]

LibreOffice Calc - Generating hyperlinks in cells

How to make DATEADD (or equivalent) work in LibreOffice Calc? [closed]

External data source with csv [closed]

Change Column Separator on CSV Export [closed]

Very long text in one Libre Calc cell. Hide/unhide tool?

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.