You can prevent Excel from converting numbers to scientific notation. This post shows how to remove scientific notation in Excel.

Finally, click on the OK button to save changes. See: How to remove Scientific Notation in Excel? 3] Set a Custom format You can also use a Custom format to enter number codes like Social ...

However, when I go to reformat them, Excel -insists- on converting the number to scientific notation--and since I'm editing the string into a non-number format (multiple spaces, parenthesis, etc ...

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.