All you have to do here, for example ... they will then show in the form of scientific notation. Excel does not give users the ability to turn off this functionality by default.