Fix Rounded Values Copied from Excel Online to Desktop Excel
Question details
The user needs to transfer numbers from Excel Online to desktop Excel without losing their underlying precision.

- 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.
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.
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.
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.
Select the source cells in desktop Excel and press Ctrl+C, or use Copy from the Home tab.
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.

Show enough decimal places before copying in Excel Online
Use this workaround when you can change the source cell format but prefer to copy from the browser.
Create an Excel template with the preferred number format
Use a template to apply a consistent decimal display to new workbooks that you or the file provider create.
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.

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.




