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