Where Excel is concerned, 15 digits is the largest it can handle, so if values go over the limit, they will then show in the form of scientific notation. Read: How to remove Text before or after ...

Preserve the first 15 digits of long numbers and convert it to scientific notation: If you enter the number 3520345723544235874452337844560238967 in a cell, for example, Excel truncates it to 15 ...

Excel truncates a numerical value of 15 digits or more to scientific notation. Excel converts numerical digits surrounding the letter E to a scientific notation.