Change the Decimal Places value to 0 ... they will then show in the form of scientific notation. Excel does not give users the ability to turn off this functionality by default.

You can change the format for these values to a Number format to remove the scientific notation. A few years ago, Excel finally implemented three toggle options that allow users to disable three ...