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 today’s dataset, we can use TRIM, UPPER, LOWER, PROPER, TEXT, CONCATENATE Functions, and Format Cells Command 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

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

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 Numbers 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 formula 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 in the entire column
**C**which has been given in the screenshot.

**Read More:** How to Convert Scientific Notation to Text in Excel

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

In this method, we will convert scientific notation to numbers by using **the UPPER function**. Please follow the instructions 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, auto-fill
**the UPPER function**to the rest of the cells in column**C**.

**Read More: **Enter Scientific Notation in Excel

### 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 Remove Scientific Notation in Excel

### 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: **Convert Scientific Notation to Text in Excel

### 5. Use the TEXT Function to Convert Scientific Notation to Numbers 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, auto-fill
**the TEXT function**to the rest of the cells in column**C**.

### 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, auto-fill
**the CONCATENATE function**to the rest of the cells in column**C**.

### 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.

## Things to Remember

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

**Download Practice Workbook**

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

## 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.