Use exponential notation

To enter a number in exponential notation:

In a cell in a numeric or null column, type three elements: a number (which can be an integer or decimal number), the letter E (which substitutes for multiplying by 10), and the exponent.

For example, the number 3200 is equal to 32 x 102 or 3.2 x 103, so you could type 32E2 or 3.2E3.

Note that entering a number using exponential notation does not necessarily mean that the number will display in that notation.