I would like to prevent Excel behavior that any large number I enter is stored as a number, then abbreviated to scientific notation. Is it possible to tell Excel 2007 to stop doing this?
Unfortunately excel does not allow you to turn this functionality off by default.
However if you select your data, right click, and click "Format cells..." and choose Number you can stop excel from changing your data to scientific notation.
This is inconvenient (yet effective) hack. Note, this is only really useful if you need to import the full number into another application (like Access) or provide the proper display.
If you format the column in question as
If you want to make ALL numbers typed within a sheet NOT to appear in scientific format, you can consider creating a template & reusing it.
When you create the template, select the whole sheet and set the default number format for all cells to "Number".
protected by Community♦ Mar 13 '14 at 0:09
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?