OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

2.19 FAQ-429 How to directly copy Excel data with more than 15 significant digits to Origin?

Last Update: 10/2/2015


When you directly copy data with more than 15 significant digits from Microsoft  \textsuperscript{\circledR} Excel into Origin, the raw data will be truncated to 15 significant digits. This is due to the working precision limit in Excel.

To get the raw data with full precision from Excel to Origin, you have to import the Excel file instead of copy and paste. To import, use File:Import:Excel(XLS, XLSX, XLSM)... from Origin menu.

Once the data are imported, to view all digits of data you can go to Tools:Options to bring up Options dialog. In the Numeric Format tab, check the Significant Digits radio box and set the Number of Digits; Or double click on a specified column to bring up the Column Properties dialog, and set significant digits in Options:Digits.


Keywords:Excel, import data, decimal places, significant digits

 

© OriginLab Corporation. All rights reserved.