A surprisingly high number of scientific papers in the field of genetics ... Researchers still have to remember to manually format columns to "Text" before you type anything in new Excel sheets ...

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), it will not un-fuck itself when I ...

In addition, you can format the display to show numbers in scientific notation, which has a power-of-ten exponent, or fixed notation, which shows no exponent unless the number is very large or small.