Sep 09 2020 08:39 AM
How to get the 16 digit number from the given number in excel.
6.12345E+15
|
I tried in different ways but last 2 digits are rounding ..
Sep 09 2020 08:41 AM
Excel keeps only 15 digits, cut the rest
Sep 09 2020 08:47 AM
can we say that its not possible to retrieve the 16 digit number from that exponent number in excel? is there any alternative ways?
Explanation
after so much of code execution,the result placing into excel sheet .but finally we got that exponent number. its big headache now.
Sep 09 2020 09:26 AM
SolutionNo, that doesn't work. Please check
15 digit limit in Excel and Last digits are changed to zeros when you type long numbers in cells of Excel for more details
Sep 09 2020 09:26 AM
SolutionNo, that doesn't work. Please check
15 digit limit in Excel and Last digits are changed to zeros when you type long numbers in cells of Excel for more details