Data Import & Export

Fix Rounded Values Copied from Excel Online to Desktop Excel

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

The user needs to transfer numbers from Excel Online to desktop Excel without losing their underlying precision.

Fix Rounded Values Copied from Excel Online to Desktop Excel
Product
Excel Online and Microsoft Excel for desktop
Device & OS
not provided
Scenario
The user copies values from a workbook in Excel Online to desktop Excel for data comparisons.
Observed behavior
The pasted values reflect the rounded numbers displayed in Excel Online rather than the full underlying values, causing comparison differences.
Before you start

Check whether the source cells contain more decimal places than are displayed, and confirm that you can open the source workbook in desktop Excel or change its number format.

Solution 1Recommended

Open the source workbook in desktop Excel before copying

Use the desktop application when you need to copy the stored values without relying on the browser's displayed formatting.

1
Open the workbook in Excel

In Excel Online, select Open in Desktop App from the workbook's editing or open options. If that option is unavailable, download the workbook and open it in desktop Excel.

2
Copy from the desktop workbook

Select the source cells in desktop Excel and press Ctrl+C, or use Copy from the Home tab.

3
Paste into the destination

Open the destination workbook in desktop Excel, select the target cells, and use Paste or Paste Special > Values. Check the pasted numbers against the source.

Open the source workbook in desktop Excel before copying
Excel's precision limit: Excel stores numbers with up to 15 significant digits. Opening the workbook in desktop Excel cannot restore digits that were already lost when the data was entered or imported.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with your data without copying it from Excel Online. WPS does not change Excel Online's copy behavior.

Open and edit Microsoft Excel XLSX and XLS filesAdjust number formats and displayed decimal places in spreadsheetsUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does a pasted number differ from the original value?

Excel Online may copy the displayed, rounded value when transferring data to desktop Excel. Open the source workbook in desktop Excel or show more decimal places before copying.

Does increasing decimal places change the stored number?

No. Use Home > Increase Decimal to show more of the stored value; the formatting itself does not change or restore the underlying number.

Can I avoid changing the number format every time?

If you create the workbooks, set the desired Number format in desktop Excel and save the workbook through File > Save As as an Excel template. You can also ask the file provider to apply the format.

Can Excel preserve more than 15 significant digits?

Excel stores numeric values with up to 15 significant digits. For identifiers or other data that require more digits, import or enter them as text rather than numbers.