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!
You should read it
- How to write exponential numbers in Word
- Power function (exponential) in Excel
- Exponential functions in Excel - Usage and examples
- Instructions to stamp negative numbers in Excel
- How to write leading zeros in Excel
- Instructions to write and read the code is correct
- How to write the above index, below index in Excel
- PI (PI Function) in Excel - How to use PI numbers in Excel
- Split numbers from strings in Excel
- How to extract numbers or text from Excel
- How to format numbers in Excel
- How to convert negative numbers to positive numbers Excel
May be interested
Conditional counting function in Excel
How to sort dates in ascending and descending ways in Excel
How to convert Vietnamese accented into unsigned very fast like Unikey
Typing, abbreviation in Word, Excel with AutoCorrect
How to use Highlight in Word - Create and delete Highlight in Word?
How to change the size of rows, columns, cells equally in Word, Excel