How to write exponential numbers in Excel

Are you entering data in Excel that includes exponents that you do not know how to write exponents in Excel? So are you looking for a way to write exponential numbers in Excel to continue your data entry process? Please refer to the way of writing exponential numbers in Excel below.

How to write exponential numbers in Excel Picture 1

If you want to write the 2nd or 3rd powers, you can quickly use the keyboard shortcut combination:

Caps (^ 2): Alt + 0178

Caps (^ 3): Alt + 0179

If you want to write other exponents for example: ({a ^ x}) or ({a ^ {left ({x - 1} right)}}) then do the following:

Step 1 : You enter a into a cell in Excel then right click and select Format Cells.

Note: you need to right click on the mouse next to the letter a.

How to write exponential numbers in Excel Picture 2

Step 2 : The Format Cells dialog box appears in the Font tab , check the box in the box before Superscript and click OK .

How to write exponential numbers in Excel Picture 3

Step 3 : You enter the exponent for example x or (x-1) you will see the number you enter is small above.

How to write exponential numbers in Excel Picture 4

To continue entering other numbers, you open the Format Cells dialog box again and uncheck the Superscript box .

How to write exponential numbers in Excel Picture 5

So you can enter normal data.

How to write exponential numbers in Excel Picture 6

Similarly if you want to write the index below you open the Format Cells dialog box and check the box in the Subscript to enter the index below.

How to write exponential numbers in Excel Picture 7

And enter the subscript if you want.

How to write exponential numbers in Excel Picture 8

So, this article has taught you how to write exponential numbers in Excel, hope this article will help you.

Good luck!