Copy a Number in Excel Without Copying the Formula

Formulas & functions · Updated November 20, 2026

To copy a formula cell’s displayed number without copying its formula, copy the cell, select where it should go, then choose Home > Paste > Values in Excel for Microsoft 365 on Windows. This pastes the calculated result as a fixed value, so it will not change when the original formula’s inputs change. You can use the same method to replace a formula with its current result in the original cell.

In this guide, “number” means the result shown in a cell, which might be a whole number, decimal, date, time, or text. Paste Values copies the underlying result, not the formula. If you also want the destination to look like the source, you may need to copy its formatting separately.

What You’ll Need

  • A workbook open in Excel. The steps below use Excel for Microsoft 365 on Windows.
  • A source cell or range containing the result you want to keep. It can contain a formula or a value entered directly.
  • A destination cell or range, unless you are replacing the formula in the source cell itself.
  • For important work, a saved copy of the workbook. Pasting values over formulas removes those formulas from the cells you replace.

Step-by-Step

  1. Check the source cell. Select the cell containing the number. Look at the formula bar above the worksheet: if it starts with an equals sign, the cell contains a formula, even if the grid displays only a number. Note the displayed result and any number format, such as currency, percentage, or date. This helps you confirm the paste worked and notice whether the destination needs formatting.
  2. Copy the source. Press Ctrl+C on Windows, or choose Home > Copy. A moving dashed border appears around the copied cell or range. Copying does not change the original formula; it only places the cell contents on the clipboard.
  3. Select the destination. Click the top-left cell where you want the fixed result to appear. If you are replacing the formula with its current result, select the source cell again. For several cells, select the matching destination range, starting at its top-left cell. Make sure the destination is the right size: pasting a multi-cell range into an area that overlaps existing data can overwrite it.
  4. Open the Paste Values command. On the ribbon, select Home, open the lower part of the Paste button, and choose the option labeled Values. In many Excel layouts, its icon shows a clipboard with 123. Do not choose the main Paste button if you need to avoid carrying over the formula; ordinary paste copies the formula as well as other cell content.
  5. Use the keyboard alternative if you prefer. After copying and selecting the destination, press Ctrl+Alt+V to open Paste Special, press V to select Values, then press Enter. Check the dialog before confirming if your Excel build shows a different selection or if you are unsure which option is active. The ribbon command is a good fallback when a shortcut behaves differently.
  6. Confirm the result. Select the pasted cell and inspect the formula bar. A successful values-only paste shows the result itself rather than a formula beginning with an equals sign. If you pasted to a separate location, change an input used by the original formula only if it is safe to do so; the pasted value should stay unchanged. Undo immediately with Ctrl+Z if you pasted into the wrong cells.
  7. Restore the appearance if needed. Values-only paste does not bring across the source cell’s formatting. If the result appears as a serial date, an unformatted decimal, or a number without its currency symbol, apply the appropriate number format to the destination. Select it and use the number-format controls on Home, or copy formatting separately using Format Painter.

For a range of formulas, the same process works: select and copy the entire source range, select a same-sized destination range, and choose Home > Paste > Values. Each destination cell receives the corresponding calculated result, rather than a copied formula. Review the range before pasting, because values-only paste replaces existing contents in the destination.

If you want to turn the formulas themselves into fixed results, copy the formula cells and paste Values back over the same cells. This removes the formulas, so the results will no longer recalculate. If you might need the formulas later, keep a separate copy of the range or save a duplicate workbook first.

Common Mistakes

Choosing regular Paste. The main Paste command usually carries formulas into the destination. A copied formula may adjust its cell references to suit the new location, which can produce a different result. Choose the specific Values option instead, then check the formula bar to verify the result is fixed.

Expecting the number format to travel with the value. Values-only paste transfers the cell value, not its formatting. A date may appear as a number, or a percentage may appear as a decimal, even though the underlying value pasted correctly. Format the destination to display the value as intended; do not assume the paste failed just because its appearance changed.

Replacing the original formula unintentionally. Pasting Values over a formula cell is a conversion: the formula is removed and only its current result remains. This is useful when intended, but it is not a temporary way to copy. If you need a reusable calculation, paste into a separate destination or make a backup before converting the source.

Overlooking errors or blanks in a range. Paste Values copies the current results of all selected cells, including blank cells and displayed errors such as #N/A or #DIV/0!. It does not correct a faulty formula. Inspect the source range first if you expect every destination cell to contain a usable number.

Selecting a destination that is too small or contains important data. A multi-cell paste can overwrite a destination range. Check the highlighted source dimensions and the destination area before confirming. If you only want one result, copy one source cell rather than a whole row or column.

Tips

Keep the displayed result and its appearance in mind as separate things. Excel stores a cell value and applies formatting to show it. For example, a value can be stored as a decimal but displayed as a percentage. Paste Values preserves the value, not necessarily the visual presentation, so apply an appropriate format after pasting when the display matters.

Use Paste Special to control exactly what you bring across. The Paste Special dialog includes options beyond Values, such as Formulas and Formats. For this task, choose Values. If you need both the fixed result and the source’s appearance, paste Values first, then copy the source and use the Formats option. This is a separate paste and lets you keep control over which parts of the cell are transferred.

Use a separate destination to compare results. When you are checking a calculation or preparing a report, place the fixed value in a new column or worksheet rather than replacing the formula immediately. Label the column clearly, such as Fixed result, and verify that it matches the original displayed result. This makes it easier to spot mistakes before removing any formulas.

Remember that a fixed result can become out of date. Once pasted as a value, it will not update when the source formula’s inputs change. That is often the point when preparing a snapshot, exporting figures, or sharing a result that should stay unchanged. If you need the destination to keep updating, use ordinary paste or retain a formula instead.

Do not confuse Paste Values with typing a number manually. A manually entered value can work, but it is easy to mistype digits, decimal points, or signs. Paste Values transfers the result directly from the source. It is usually the safer choice for a one-off copy, especially when the source has many decimal places or contains a calculated date or time.

On Mac, use the ribbon or menu rather than assuming Windows shortcuts apply. In Excel for Mac, copy with Command+C, select the destination, and choose Home > Paste > Values (or the equivalent Paste Special Values option shown in your version). The precise keyboard shortcut for Paste Special can vary with the Mac version and keyboard settings, so the ribbon command is the dependable route. In Excel for the web, use the Home tab’s paste menu and choose Values if that option is available in your interface.

Troubleshooting

The destination still shows a formula. You may have selected regular Paste instead of Values, or the Paste Special dialog may not have been set to Values. Undo the paste, copy the source again, and choose the explicit Values command. Then select the destination and check the formula bar: if it shows the original calculation, repeat the paste using the ribbon menu.

The pasted number looks wrong, but the formula bar shows a number. The value may be correct while its format differs. For example, Excel may display a date as a serial number or a percentage as a decimal. Select the cell and apply the intended number format from the Home tab. If the formula bar shows a different value than expected, compare it with the source and confirm you copied the correct cell.

The pasted result is an error. Paste Values preserves the result the source formula currently displays, including formula errors. Go back to the source and investigate the error before copying again. If the source error comes from a missing lookup, invalid reference, or division by zero, fix that issue first; pasting the error as a value will not repair it.

The pasted value changes when you edit the source. That usually means a formula was pasted rather than a fixed value. Undo, then paste using Home > Paste > Values. If the destination is part of a table or a spill range, check whether Excel is filling formulas automatically or restricting edits. In particular, a cell inside a dynamic array spill range may not be independently editable; paste the fixed result outside that spill area or convert the full intended output range where appropriate.

The Values option is unavailable or the paste does nothing. Confirm that you copied a cell or range and that the selection is still active. If you copied content from another application, Excel may offer different paste choices. Copy the source cell again inside Excel, select the destination, and use the ribbon’s Paste menu. If the workbook or worksheet is protected, check whether editing the destination is allowed; use an unprotected destination or ask the workbook owner to grant access.

You pasted over the wrong cells. Press Ctrl+Z on Windows immediately, or Command+Z on Mac, if the paste is still the most recent action. Check the source and destination selections, then repeat carefully. If you have already made other changes, avoid saving over the only copy until you have checked whether the unwanted paste can be reversed safely.

Frequently Asked Questions

How do I copy only the number from a formula cell?
Copy the formula cell, select the destination, and choose Home > Paste > Values. Excel pastes the formula’s current result rather than the formula itself.

Can I replace a formula with its current number?
Yes. Copy the cell, select that same cell, and paste Values. The formula is removed and replaced by its current result, which will no longer recalculate. Save a backup first if you may need the formula later.

Will Paste Values preserve a date, currency, or percentage format?
Not necessarily. Values-only paste transfers the underlying result but not the source formatting. Apply the required date, currency, percentage, or other number format to the destination if its appearance is important.

Can I paste the results of many formulas at once?
Yes. Copy the whole source range and paste Values into a same-sized destination range. Check for blanks, errors, and existing destination data first, because the paste transfers each cell’s result and can replace contents in the destination.

Does the pasted number update when the original formula changes?
No. A pasted value is a snapshot of the result at the time of the paste. It stays fixed when the original formula or its inputs change. Use a formula or ordinary paste if you need a live, updating calculation instead.

Can I use the same method in Excel for Mac or Excel for the web?
Yes. Look for the Values option in the Home tab’s Paste menu or Paste Special options. On Mac, use Command+C to copy; keyboard shortcuts for Paste Special may differ, so the ribbon menu is a reliable alternative.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.