In Microsoft Excel if a cell contains more than 15 digits, Excel changes any digits past the fifteenth place to zeros. This is due to Excel following the IEEE 754 specification for how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number and changes digits after the fifteenth place to zeros.
Note: This behavior occurs only if the cell is formatted as Number, and the number that is entered exceeds 15 digits.
- This information is still available in the export, you will need to either use another program if access to this information is needed, or format those cells to "Text" instead of "Number".
In an effort to supply information as quickly as possible, this article has been published prior to a formal technical review, and is subject to factual, grammatical, and various structural errors. Data may be incomplete, misordered, or incorrect.
This additional disclaimer will be removed upon formal review of this article. The standard Punchh Inc. KB Disclaimer still applies, and can be found at: https://support.punchh.com/hc/en-us/articles/360040100273-Punchh-Inc-Knowledge-Base-Disclaimer
If further assistance is required, submit a ticket to Punchh Support. (For help submitting a ticket, click here)