excell auto scientific format 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).