Hi all, I have run an API and got as a response a 16 digits number, when I atempted to save this info into an excel file for aparent no reason the last digit turns into zero! My solution was to add a single quote prior to the number, to turn into a string, it worked. Even though I found a solutio…

@William_Blech_Sister , Check this article, exact case explained by Microsoft. [image] Last digits are changed to zeros when you type long numbers in cells of Excel... Describes that Excel can store only 15 significant digits in a number. If the number that you type contains more than 1…

Last number of a digit turns into zero

Feedback Studio

sarathi125 (Parthasarathi) June 27, 2022, 12:56pm 3

@William_Blech_Sister,

Check this article, exact case explained by Microsoft.

Topic		Replies	Views
XLS - Write Cell - long number Studio studio , question , activities_panel	4	1024	July 14, 2022
When i try write a DT to excel, it deletes zeros for only 6 digit numbers. Do you have any idea how to solve this problem Activities excel , activities , question	4	1380	August 17, 2021
Excel drops the last digit Help excel , activities	2	1639	October 29, 2018
Last digits are changed to zeros while writing data table to excel or csv Activities excel , activities , question	5	109	July 5, 2024
Datatable content discrepancy when paste onto excel Help datatable , excel , activities , question	3	831	November 30, 2019

Last number of a digit turns into zero

Related topics