how to stop excel from converting to scientific notation code example
Example: how to prevent excel from converting numbers to scientific notation
This worked for me in Excel 2010/16. Just select the column, right click,
Format cells, Custom and choose the option that says 0 (second option
below General).