Monday, 23 December 2019

Turn off scientific notation in Excel


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

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...