# Copy Number Not Formula – Excel & Google Sheets

*This tutorial demonstrates how to copy a number without its formula in Excel and Google Sheets.*

## Copy-Paste Values

In Excel, if you copy a cell containing a formula to another location, using the simple copy-paste method, you will copy the formula, not a number. Say you have the following formula in cell B4.

The result of the SUM Function in cell B4 is 30. If you want to copy this number to cell C4 and not the formula, follow these steps:

- Right-click the cell you want to copy (B4), and click
**Copy**(or use the keyboard shortcut**CTRL + C**).

- Right-click the cell where you want to paste the number (C4), and click the
**Paste values icon**(or use the**keyboard shortcut**).

As a result, only the number, and not the formula, is pasted.

**Note:** If you use the simple paste (**CTRL + V**), the formula from B4 is copied with updated cell references (C1:C3), and the result would be 0.

## Copy-Paste Values in Google Sheets

In a similar way, you can copy just the number in Google Sheets.

- Right-click the cell you want to copy (B4), and click
**Copy**(or use the keyboard shortcut**CTRL + C**).

- Right-click the cell where you want to paste a number (C4), click
**Paste special**, and choose**Values only**(or use the keyboard shortcut**CTRL + SHIFT + V**).

As a result, only the result of the formula (30) is copied from B4 to C4.