In this article, weâ€™re going to show you **4** methods of how to **enter scientific notation** in **Excel**. Weâ€™ve taken a dataset(**data source**) containing **3 columns**: **Movie**, **Year**, and **Revenues**. We aim to change the formatting of the **Revenue** column to **scientific notation**.

**Table of Contents**hide

## Download Practice Workbook

## 4 Ways to Enter Scientific Notation in Excel

### 1. Using Number Format to Enter Scientific Notation in Excel

Weâ€™ll use **the** **Number Format** option in **Excel** to **enter scientific notation** in this method.

**Steps:**

- Firstly, select the
**cell**range**D5**:**D10**. - Secondly, from the
**Home**tab >>> click on the**DropDown box**from the**Number**section.

- Finally, click on
**Scientific**.

Thus, weâ€™ve **entered scientific notation** in **Excel**.

### 2. Utilizing the Format Cells Option to Enter Scientific Notation in Excel

For the second method, weâ€™ll use the **Format Cells** option to **enter scientific notation**.

**Steps:**

- Firstly, select the
**cell**range**D5**:**D10**. - Secondly,
**right-click**to bring up the**Context**menu.

- Thirdly, click on
**Format cellsâ€¦**from the menu.

**Format Cells** **dialog box** will appear.

- Then, from the
**Category:**click on**Scientific**. - After that, we can change the
**Decimal places**of our number.

Although weâ€™ve set it to **3**, this is totally optional.

- Finally, click on
**OK**.

In conclusion, we implemented yet another method to **enter scientific notation**.

### 3. Manually Typing to Enter Scientific Notation in Excel

We can type in the **scientific notation** manually too. From the dataset, we can see that there are **10** **digits** in each **Revenue** value.

**Steps:**

- Firstly, type â€ś
**2.847379794e9**â€ť in**cell D5**.

**Note:** The value â€ś**2847379794**â€ťÂ from **cell D5** can be written as, â€ś**2.847379794e9**â€ť or â€ś**28.47379794e8**â€ť. Here, the â€ś**e**â€ť is not case sensitive, which means â€ś**e **or **E**â€ť both will provide the same result.

- Secondly, press
**ENTER**.

Here, the value is in **scientific notation**.

Moreover, we can repeat it for the rest of the **cells**.

**Note:** If you have many **cells**, this method is not efficient for that. Therefore, try the other methods for that.

### 4. Enter Scientific Notation in Excel and Converting It to X10 Format

For the last method, weâ€™ll convert the **scientific notation** in **Excel** to **X10** format. To do that, weâ€™ll use **the LEFT function**, **the TEXT function**, and **the RIGHT function**.

**Steps:**

- Firstly, type the following formula in
**cell E5**.

`=LEFT(TEXT(D5,"0.00E+0"),4) & "x10^" & RIGHT(TEXT(D5,"0.00E+0"),2)`

**Formula Breakdown**

In this formula, weâ€™re using the **LEFT** and the **RIGHT** functions to extract the values before and after â€ś**E**â€ť respectively. On top of that, weâ€™re using the **TEXT** function to convert the values into the text as in the **scientific notation **format. Finally, weâ€™re joining the values with the **ampersands**.

**TEXT(D5,â€ť0.00E+0â€ł)****Output: â€ś2.85E+9â€ť**.- The
**TEXT**function converts the value into text in the**scientific notation**.

**LEFT(â€ś2.85E+9â€ť,4)****Output: â€ś2.85â€ť**.- The
**LEFT**function returns the values up to the**4th**position from the left side.

**RIGHT(â€ś2.85E+9â€ť,2)****Output: â€ś+9â€ť**.- The
**LEFT**function returns the values up to the**2nd**position from the right side.

- Finally, our formula reduces to,
**â€ś2.85â€ť & â€śx10^â€ť & â€ś+9â€ť****Output: â€ś2.85Ă—10^+9â€ť**.- Weâ€™re joining the values with the
**ampersands**.

- Secondly, press
**ENTER**.

Thus, weâ€™ve changed our format.

- Finally,
**AutoFill**the formula using the**Fill Handle**.

In conclusion, weâ€™ve changed the **scientific notation** to theÂ â€ś**X10**â€ť format.

**Read More: How to Display Power in Excel (6 ways)**

## Practice Section

Weâ€™ve included practice datasets in the **Excel** file for your practice.

## Conclusion

Weâ€™ve shown you **4** methods of how to **enter scientific notation** in **Excel**. Moreover, if you face any problems understanding these, feel free to comment below. Thanks for reading, keep excelling!