Calculation Issues

Copy an Excel Cell's Displayed Value Instead of Its Actual Value

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

The user wants to copy or calculate with the rounded value shown in an Excel cell rather than its underlying value.

How to Copy an Excel Cell's Displayed Value Instead of Its Actual Value
Product
Microsoft Excel
Device & OS
not provided
Scenario
A cell is formatted to show fewer decimal places than its stored value, and the displayed precision is needed for copying or calculation.
Observed behavior
A cell containing 4.3456 displays 4.35, but Excel uses 4.3456 in calculations.
Before you start

Check how many decimal places the source cell displays and identify the cell reference you want to use. Changing the number format alone does not round the stored value.

Solution 1Recommended

Round the value before copying or calculating

Use ROUND to create a value that matches a cell displayed to a fixed number of decimal places.

1
Enter a rounding formula

In an empty cell, enter =ROUND(H2,2) to round the value in H2 to two decimal places. Replace H2 and 2 with your cell reference and displayed decimal places.

2
Copy the rounded result

Select the formula cell and press Ctrl+C, then select the destination and use Home > Paste > Paste Special > Values to paste the rounded number without the formula.

3
Round within a calculation

To calculate directly with the rounded value, enter a formula such as =ROUND(H2,2)*100. If H2 contains 4.3456, the result is 435.

Round the value before copying or calculating
Match the format: The ROUND formula above assumes a standard number format. Percentage, scientific, or scaled custom formats may require a different rounding precision.
Work with rounded values

Copy Rounded Cell Values in WPS Spreadsheet

Use ROUND in WPS Spreadsheet to match a cell's displayed decimal precision, then paste the result as a value.

  1. 1. Open the workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
  2. 2. Round the source value: In an empty cell, enter =ROUND(H2,2), replacing H2 with your source cell and 2 with the number of decimal places you need.
  3. 3. Copy the result: Select the formula cell and use Copy on the Home tab.
  4. 4. Paste the value: Select the destination cell and use Home > Paste Special > Values to paste the rounded number without its formula.
Round values before copying or calculatingOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel calculate with more decimal places than I see?

Cell formatting changes the display, not the stored number. Use a formula such as =ROUND(H2,2) when you need calculations to use two decimal places.

Does Paste Special > Values copy the displayed precision?

Not by itself. Paste Special > Values removes formulas but retains the underlying value. First use ROUND in a helper cell, then copy and paste that result as a value.

How can I multiply the displayed two-decimal value by 100?

Enter =ROUND(H2,2)*100 in a cell. For an underlying value of 4.3456 in H2, the formula returns 435.

Can I undo Excel's precision as displayed setting?

You can turn it off under File > Options > Advanced, but doing so does not restore precision that was already discarded from stored values.