SOLVED

exponent number to number conversion

%3CLINGO-SUB%20id%3D%22lingo-sub-1649052%22%20slang%3D%22en-US%22%3Eexponent%20number%20to%20number%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649052%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20get%20the%2016%20digit%20number%20from%20the%20given%20number%20in%20excel.%3C%2FP%3E%3CTABLE%20width%3D%2298%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2298%22%3E%3CP%3E6.12345E%2B15%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20tried%20in%20different%20ways%20but%20last%202%20digits%20are%20rounding%20..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1649052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649070%22%20slang%3D%22en-US%22%3ERe%3A%20exponent%20number%20to%20number%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778499%22%20target%3D%22_blank%22%3E%40rajeshmanepalli987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20keeps%20only%2015%20digits%2C%20cut%20the%20rest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649122%22%20slang%3D%22en-US%22%3ERe%3A%20exponent%20number%20to%20number%20conversion%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20we%20say%20that%20its%20not%20possible%20to%20retrieve%20the%2016%20digit%20number%20from%20that%20exponent%20number%20in%20excel%3F%20is%20there%20any%20alternative%20ways%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExplanation%3C%2FP%3E%3CP%3Eafter%20so%20much%20of%20code%20execution%2Cthe%20result%20placing%20into%20excel%20sheet%20.but%20finally%20we%20got%20that%20exponent%20number.%20its%20big%20headache%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 ..

 

3 Replies
Highlighted

@rajeshmanepalli987 

Excel keeps only 15 digits, cut the rest

Highlighted

@Sergei Baklan 

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.

 

Highlighted
Best Response confirmed by rajeshmanepalli987 (Occasional Contributor)