hisham said:
what is a scientific notation
In Excel, you can represent any number that way by selecting the Scientific
format with some number of decimal places.
By default, Excel will represent the number in the form x.yyyE+zz, where the
number of "y" digits depends on the format.
xE+zz means x times 10 to the z power. For example, 2E+6 is 2,000,000. And
2E-6 is 0.000002.
Scientific notation has many purposes. Typically, it is used to express
very large and very small numbers in a concise manner. But it can also be
used, for example, when you want to express all numbers in a consistent way
(e.g. the same number of digits) regardless of their magnitude.