Ctrl + C and then Alt + E + S + V + Enter. This requires inputting a formula in a column next to the number. This method shouldn't disturb any text that might be in your list (read the bottom of this section for the exception).
Input a Number so it's Never Converted to Scientific Format There are a number of ways to do this and what you should use depends on your dataset. How to convert scientific numbers to show their full amount this method also allows you to retain the appearance of text in case you have a mixed list of text and numbers in scientific notation format.
