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?
Answer
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.
No comments:
Post a Comment