Large numbers are automatically placed into scientific notation by default in **Microsoft Excel**. In fact, Excel can handle 11 digits before it converts the numbers to scientific notation. Now, sometimes you may want to display all the numbers instead of the scientific notation. Considering this, the following article describes 7 easy ways how to stop Excel from changing numbers to scientific notation.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from the link below.

## 7 Ways to Stop Excel from Changing Numbers to Scientific Notation

Here, weâ€™ll utilize the various options and functions that Excel offers to change scientific notation back to numbers. Therefore, without further delay, letâ€™s see each process in detail.

Considering the **Sales Data** in the **B4:D14 **cells, where we have the **Customer Name**, **Invoice Number**, and the **Sales** in USD. Here, the *Invoice Number* consists of 13 digits, which are stored in scientific notation by default, as shown in Column **C **(see the following image). However, we want to display these as regular numbers and stop Excel from changing the numbers to scientific notation.

Here, we have used the *Microsoft Excel 365* version; you may use any other version according to your convenience.

__Method-1__: Using Format Cells Option

Letâ€™s begin with a quick and simple method, that is to say, weâ€™ll use the **Format Cells **option to change the *Invoice Numbers* to regular numbers. So, letâ€™s see it in action.

ðŸ“Œ ** Steps**:

- At the very beginning, make a copy of the
*Invoice Number*column >> select the**D5:D14**cells >> press the**CTRL + 1**keys.

Now, this opens the **Format Cells** dialog box.

- Next, go to the
**Number**tab >> change the**Decimal places**to**0**>> click the**OK**button.

Finally, the results should look like the image shown below.

**Read More:** **How to Stop Excel from Auto Formatting Numbers (3 Easy Ways)**

__Method-2__: Utilizing UPPER Function

If youâ€™re one of those people who enjoy using Excel functions, then our next method has you covered. While the **UPPER function** typically changes a string of text to upper-case, it can also transform the scientific notation to numbers. Hence, follow these simple steps below.

ðŸ“Œ ** Steps**:

- In the first place, move to the
**D5**cell and enter the formula given below.

`=UPPER(C5)`

Here, the **C5 **cell indicates the *Invoice Number*.

- Then, use the
**Fill Handle Tool**to copy the formula into the cells below.

Eventually, the output should look like the picture shown below.

__Method-3__: Applying TRIM Function

Another way to convert the numbers from scientific notation to regular numbers involves using the **TRIM function**. Normally, the **TRIM **function primarily removes extra spaces from a string of text, however, it can also convert scientific notation to numbers. Therefore, let us go through the steps.

ðŸ“Œ ** Steps**:

- Initially, navigate to the
**D5**cell and insert the expression given below.

`=TRIM(C5)`

In this formula, the **C5 **cell represents the *Invoice Number*.

Lastly, your results should look like the screenshot given below.

**Similar Readings**

**[Fixed!] Excel Changing Dates to Random Numbers (3 Solutions)****How to Stop Autocorrect in Excel for Dates (3 Quick Ways)****Why Excel Is Changing My Numbers to Decimals (with Solutions)**

__Method-4__: Employing CONCATENATE Function

You can also apply the **CONCATENATE function** to change the scientific notation in the dataset. Though the **CONCATENATE **function mainly combines two or more strings in a cell, it can stop Excel from changing numbers to scientific notation. So, just follow the steps.

ðŸ“Œ ** Steps**:

- First and foremost, jump to the
**D5**cell and type in the following expression.

`=CONCATENATE(C5)`

Here, the **C5 **cell points to the *Invoice Number*.

Consequently, the output should look like the screenshot shown below.

__Method-5__: Inserting a Leading Apostrophe

For our next method, weâ€™ll** insert a leading apostrophe** to change from scientific notation to regular numbers. So, letâ€™s see the process in detail.

ðŸ“Œ ** Steps**:

- Initially, copy the
*Invoice Number*from the**C5**cell >> paste it into the**D5**cell >> insert a leading apostrophe.

- Likewise, repeat the same process for the other cells, and the output should look like the image given below.

__Method-6__: Adjusting Width of Column

Sometimes Excel displays the numbers in scientific notation because the column width is insufficient and luckily there is a simple fix for this issue. Now, allow me to demonstrate the process in the steps below.

Assuming the **List of Employees** dataset in the **B4:D14 **cells. Here, the dataset shows the **ID**, **Names**, and **Department **of employees respectively. Now, the *ID *numbers are shown in scientific notation and weâ€™d want to change them to regular numbers.

ðŸ“Œ ** Steps**:

- To begin with, hover the cursor above the column, here it is column
**B**>>**Double-click**on the mouse.

Lastly, this should generate the results shown in the picture below.

__Method-7__: Using Text to Columns Wizard

Excelâ€™s built-in **Text to Columns** wizard is also a handy way to change the scientific notation in your dataset. So, just follow along.

ðŸ“Œ ** Steps**:

- First, select the
**D5:D14**cells >> move to the**Data**tab >> click on the**Text to Columns**button.

Now, this opens the **Text to Columns** wizard.

- Second, select the
**Fixed width**option >> click on the**Next**button.

- Third, hit the
**Next**button again to go to the next page.

- Lastly, select the
**Text**option >> press the**Finish**button.

As a note, Excel may show an error that you can ignore by clicking the **Ignore Error **option.

Subsequently, the results should look like the screenshot shown below.

**Read More:** **How to Stop Excel from Rounding 16 Digit Numbers (2 Easy Ways)**

## Things to Remember

As a note, you should keep this in mind when changing a number from scientific notation to a regular number.

- First, the
**UPPER**,**TRIM**, and**CONCATENATE**functions can handle a maximum of**20**digits before they too automatically convert the numbers to scientific notation. - Second,
**adjusting the column width method**is applicable if the number of digits is**11**or less than**11**, which means there is insufficient space to display all the digits.

## Practice Section

We have provided a** Practice** section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

## Conclusion

I hope this article helps you understand how to stop Excel from changing numbers to scientific notation. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website **ExcelDemy**.