# 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: **28,197 times**

Last updated: **Oct 19 '13**

Are there plans for a "papercut" project for libreoffice [closed]

Paste hangs LibreOffice Calc [closed]

How do I export a chart in an image format from LibreOffice Calc? [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

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.