Copy an Excel Cell's Displayed Value Instead of Its Actual Value
Question details
The user wants to copy or calculate with the rounded value shown in an Excel cell rather than its underlying 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.
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.
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.
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.
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.
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.

Set workbook precision as displayed in Excel
Use this workbook-wide setting only when you intend to change stored values to their displayed precision.
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. Open the workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
- 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. Copy the result: Select the formula cell and use Copy on the Home tab.
- 4. Paste the value: Select the destination cell and use Home > Paste Special > Values to paste the rounded number without its formula.

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.




