How to Type Exponential in Excel (6 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is a handy software. We use Excel functions and features for our educational, business, and other daily life purposes. Furthermore, Excel provides some cool functions to write exponential in our workbooks. This article will show you 6 simple methods to type exponential in Excel.


How to Type Exponential in Excel: 6 Easy Ways

Typing exponential in Excel can be really cumbersome if we consider a large dataset. Alternatively, we can quickly write exponential with Excel tools and functions. Exponential is a mathematical term that we use in our various equations. With that in mind, in this article, I will show 6 easy methods to type exponential in Excel. For instance, we take a dataset that represents the compound interest rate of ABC Bank.

how to type exponential in excel


1. Apply Superscript Command to Add Exponential

Excel provides some useful default text formats to modify our numbers into texts. To demonstrate this method, we will convert the data in our cell into text format. Afterward, we will add Superscript to implement the strategy. To do so, let’s follow the steps.

Steps:

  • First, in the D column, type the base number 1.06 and their exponentials 1,2,3,4,5 side by side.
  • See the below picture to better understand.

Apply Superscript Command to Add Exponential

  • Select the range D5:D9.
  • After that, right-click on the selected range and go to Format Cells.

  • Subsequently, the Format Cells dialogue box will pop up.
  • Click Number > Text > OK to format the range in text.

  • Upon formatting in text, select the exponential text and right-click on it.
  • Now, tap Format Cells.

  • Eventually, the Format Cells dialogue box will open.
  • Check the Superscript option and hit OK.

  • As a result, the exponential appears in the dataset.


2. Create Excel CHAR Formula for Printing Exponential

This method will use the CHAR function to display exponential in Excel. The Excel CHAR function returns a specific character when we input a code number. CHAR formula codes to display exponential are:

To type 1, type =CHAR(185)

For displaying exponential 2, type =CHAR(178)

To print exponential 3, type =CHAR(179)

Let’s try to implement this function with the procedures given below.

Steps:

  • In cell D5, type the CHAR formula to display exponential as 1,
=C5&CHAR(185)
  • After that, press Enter.

Create Excel CHAR Formula for Printing Exponential

  • Similarly, in cell D6, type the formula to display exponential 2,
=C6&CHAR(178)
  • Also, in D7, type the formula for exponential 3,
=C7&CHAR(179)
  • Thus, we obtain our desired result.

Note: Excel CHAR function is limited to the exponential 1,2 &3. We do not raise the exponential any further than 3.

Read More: How to Display Exponents in Excel


3. Press Keyboard Shortcuts to Apply Exponential

Using keyboard shortcuts is an easy way to add exponential to our dataset. Therefore, we will use keyboard shortcuts in this method. To do so, follow these steps.

Steps:

  • Firstly, double-click on the cell to enter edit mode.
  • Next, hold Alt and press the 0185 buttons.

Press Keyboard Shortcuts to Apply Exponential

  • Later, release Alt to display the exponential 1.

  • Similarly, for exponential 2,3 press the Alt + 0178 and Alt + 0179 keys respectively.
  • Hence, we get the desired results.

How to Type Exponential in Excel output using Keyboard Shortcut


4. Go to Equation Options to Display Exponential

In this method, we will print the exponential using Equation options under the Symbols group. Let’s follow the procedures.

Steps:

  • First of all, go to Insert > Symbols.

Go to Equation Options to Display Exponential

  • Next, tap the Equation button shown below.

  • Afterward, click Script and then tap Superscript.

  • As a result, a type option box will pop up.
  • Here, input the base number and exponential as you wish.

  • Lastly, we get our results.

How to Type Exponential in Excel output using Equation Option


5. Embed Excel VBA to Add Exponential

Adding exponential is easy and time-saving if we implement it through Excel VBA code. We can write a simple code and run this to get our desired exponentials. Let’s follow up on the procedures.

Steps:

  • First, go to Developer > Visual Basic to open the Visual Basic window.
  • After that, tap Insert and then Module to create a module.
  • Now, in the module box, type the following VBA code:
Sub InputExpo3()
    Selection.NumberFormat = "0" & Chr(179)
End Sub
Sub InputExpo2()
    Selection.NumberFormat = "0" & Chr(178)
End Sub
Sub InputExpo1()
    Selection.NumberFormat = "0" & Chr(185)
End Sub

Embed Excel VBA to Add Exponential

  • Upon writing the code, close both windows.
  • Later, go to View > Macros > View Macros.

  • Eventually, the Macro dialogue box will pop up.
  • To type exponential 1, select InputExpo1 and tap Run.

  • Similarly, add exponential 2 & 3.
  • Lastly, we get the desired result.

How to Type Exponential output using Excel VBA


6. Use Custom Formatting to Type Exponential in Excel

Excel provides some custom features to display exponential. Using a custom format and keyboard shortcuts, we can add exponential to our dataset. To illustrate, we will customize Format Cells to display exponential. Follow these steps:

Steps:

  • First of all, right-click on D5.
  • Later, select Format Cells as shown below.

Use Custom Formatting to Type Exponential in Excel

  • As a result, a Format Cells dialogue box will pop up.
  • Next, click Number > Custom > Type.
  • Now, write 00.0 in the Type box.
  • Also, hold Alt and press 0185.
  • Release Alt to add exponential 1 on the base.
  • Lastly, hit OK.

  • Similarly, to add exponential 2, type 00.0 in the Type box.
  • Meantime, tap and hold Alt and press 0178.

  • In the same way, for exponential 3, hold the Alt key then tap 0179, and release Alt.

  • Thus, we get the exponentials in our dataset.

How to Type Exponential in Excel Output using Custom Formatting


Download Practice Workbook

You can download this workbook to practice yourself.


Conclusion

In conclusion, we have discussed some easy ways to type exponential in Excel. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please leave any further queries or recommendations in the comment box below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Yousuf Khan
Yousuf Khan

Hello! This is MD Yousuf Khan. I am a graduate & post-graduate in Information Technology from Jahangirnagar University, Bangladesh. Currently, I am writing articles for ExcelDemy. I am an independent, self-motivated person with enthusiasm to learn new things, and always try to do my best in any work assigned to me.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo