Let's understand how to use the function using an example. Excel allows us to convert the format of the cell to scientific format.įor example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power.Īll of these might be confusing to understand. In simple words, sometimes working with mathematical operations on a sheet. Number can be changed to percentage, date, time, currency and scientific number.
The Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to the nth power. In this article, we will learn How to use Scientific formatting in Excel.
