In **Microsoft Excel**, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the default features of MS **Excel **is to convert a number into scientific notation if it contains more than 11 digits. In our today’s dataset, we can use **TRIM****, ****UPPER****, ****LOWER****, ****PROPER****, ****TEXT****, ****CONCATENATE**** Functions,** and **Format Cells Command **also to convert scientific notation to numbers. In this article, we’ll learn **seven **quick and suitable ways to convert scientific notation to numbers in **Excel **effectively with appropriate illustrations.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

## 7 Suitable Ways to Convert Scientific Notation to Number in Excel

Let’s say, we have a dataset that contains information about several **scientific notations **in column **B**, and we will convert these **scientific notations** to **numbers **by applying **Excel **formulas. Here’s an overview of the dataset for today’s task.

### 1. Apply the TRIM Function to Convert Scientific Notation to Number in Excel

The easiest and most time-saving way is **the TRIM function** to convert scientific notation to numbers in **Excel**. From our dataset, we will convert scientific notation to numbers. To do that, please follow the steps below.

**Step 1:**

- First, select cell
**C5**to convert scientific notation to numbers.

- Now, type
**the TRIM function**in the**Formula Bar.****The TRIM function**is,

`=TRIM(B5)`

- Where
**B5**is the cell reference of scientific notation.

- Further, press
**Enter**on your**keyboard**and you will be able to get the return of**the TRIM function**and the return is**52135043051243200**.

**Step 2:**

- After that, place your
**cursor**on the**Bottom-Right**side of**cell C5**and an**autoFill sign**will appear in front of you. Now, drag the**autoFill sign**downward.

- While completing the above process, you will be able to convert scientific notation to numbers to the entire column
**C**which has been given in the screenshot.

**Read More: How to Convert String to Number in Excel VBA (3 Methods)**

### 2. Use the UPPER Function to Convert Scientific Notation to Number in Excel

In this method, we will convert scientific notation to numbers by using **the UPPER function**. Please follow the instruction below to learn!

**Steps:**

- First of all, select cell
**C5**and write down**the UPPER function**in that cell.**The UPPER function**is,

`=UPPER(B5)`

- Where
**B5**is the cell reference of scientific notation.

- Hence, simply press
**Enter**on your**keyboard**and you will be able to get the return of**the UPPER function**and the return is**52135043051243200**.

- After that, autoFill
**the UPPER function**to the rest of the cells in column**C**.

**Read More: How to Convert Percentage to Number in Excel (5 Easy Ways)**

### 3. Insert the LOWER Function to Convert Scientific Notation to Number in Excel

You can also use **the LOWER function** to convert scientific notation to numbers in Excel. To convert scientific notation to numbers in **Excel **by using **the LOWER function**, follow the steps below to learn!

**Steps:**

- To convert scientific notation to numbers, select cell
**C5**first and write down**the LOWER function**in that cell.**The LOWER function**is,

`=LOWER(B5)`

- Where
**B5**is the cell reference of scientific notation.

- After that, simply press
**Enter**on your**keyboard**and you will get**52135043051243200**as the return of**the LOWER function**.

- Hence, autoFill
**the LOWER function**to the rest of the cells in column**C**that has been given in the below screenshot.

**Read More:** **How to Convert Date to Number in Excel (4 Methods)**

### 4. Apply the PROPER Function to Convert Scientific Notation to Number in Excel

**The PROPER function** is also the easiest and most time-saving way is to convert scientific notation to numbers in **Excel**. To do that, please follow the steps below.

**Step 1:**

- First, select cell
**C5**to convert scientific notation to numbers.

- Now, type
**the PROPER function**in the**Formula Bar.****The PROPER function**is,

`=PROPER(B5)`

- Where
**B5**is the cell reference of scientific notation.

- Further, press
**Enter**on your**keyboard**and you will be able to get the return of**the PROPER function**and the return is**52135043051243200**.

**Step 2:**

- After that, place your
**cursor**on the**Bottom-Right**side of**cell C5**and an**autoFill sign**will appear in front of you. Now, drag the**autoFill sign**downward.

- While completing the above process, you will be able to convert scientific notation to numbers to the entire column
**C**which has been given in the screenshot.

**Read More: How to Fix Convert to Number Error in Excel (6 Methods)**

**Similar Readings**

**How to Convert String to Long Using VBA in Excel (3 Ways)****Convert String to Double in Excel VBA (5 Methods)****How to Bulk Convert Text to Number in Excel (6 Ways)**

### 5. Use the TEXT Function to Convert Scientific Notation to Number in Excel

Using **the TEXT function** is another way to convert scientific notation to numbers in **Excel**. Please follow the instructions below to learn!

**Steps:**

- First of all, select cell
**C5**and write down**the TEXT function**in that cell.**The TEXT function**is,

`=TEXT(B5, “0”)`

- Where
**B5**is the cell reference of scientific notation, “**0”**is the number format.

- Hence, simply press
**Enter**on your**keyboard**and you will be able to get the return of**the TEXT function**and the return is**52135043051243200**.

- After that, autoFill
**the TEXT function**to the rest of the cells in column**C**.

**Read More:** **How to Convert Text to Number with Excel VBA (3 Examples with Macros)**

### 6. Apply the CONCATENATE Function to Convert Scientific Notation to Number in Excel

Now we will apply **the CONCATENATE function** to convert scientific notation to numbers in **Excel**. Please follow the steps below to learn!

**Steps:**

- First of all, select cell
**C5**and write down**the CONCATENATE function**in that cell.**The CONCATENATE function**is,

`=CONCATENATE (B5)`

- Where
**B5**is the cell reference of scientific notation.

- Further, simply press
**Enter**on your**keyboard**and you will be able to get the return of**the CONCATENATE function**and the return is**52135043051243200**.

- Hence, autoFill
**the CONCATENATE function**to the rest of the cells in column**C**.

**Read More: How to Convert Exponential Value to Exact Number in Excel (7 Methods)**

### 7. Perform the Format Cell Command to Convert Scientific Notation to Number in Excel

We’ll convert scientific notation to numbers in **Excel **by applying the **custom format**. Please follow the instructions below to learn!

**Step 1:**

- First, select cells from
**B5**to**B13**and copy these cells by applying**Ctrl + C**as the**keyboard shortcuts**. Then press**Ctrl + V**to paste the copying cells in column**C**.

- After that, from your
**Home**ribbon, go to,

**Home → Number → Arrow Button**

**Step 2:**

- Hence, a window named
**Format Cells**will instantly pop up. From the**Format Cells**window, firstly, select**Number**. Secondly, select**Custom**from the**Category**Thirdly, select “**0”**from the**Type**box. At last press**OK.**

**Step 3:**

- After completing the above process, you will be able to convert scientific notation to numbers that have been given below screenshot.

**Read More: How to Convert Degrees Minutes Seconds to Decimal Degrees in Excel**

## Things to Remember

👉 You can press **Ctrl + 1 simultaneously** to pop up the **Format Cells** window instead of the **Home ribbon**.

## Conclusion

I hope all of the suitable methods mentioned above to combine cells will now provoke you to apply them in your **Excel** spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.