Forum Discussion
exponent number to number conversion
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 ..
No, 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
3 Replies
Excel keeps only 15 digits, cut the rest
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.
No, 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
