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

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. Figure A shows an example of each ...

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.

By default, Microsoft Excel displays cells that contain a number with more than 12 characters as scientific notation. Follow these three simple steps to change how Excel formats these large numbers.