How to Convert Scientific Notation to Number in Excel (7 Methods)

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.


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.

convert scientific notation to number in excel


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.

Apply the TRIM Function to Convert Scientific Notation to Number in Excel

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

Apply the TRIM Function to Convert Scientific Notation to Number in Excel

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.

Apply the TRIM Function to Convert Scientific Notation to Number in Excel

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.

Use the UPPER Function to Convert Scientific Notation to Number in Excel

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

Use the UPPER Function to Convert Scientific Notation to Number in Excel

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

Use the UPPER Function to Convert Scientific Notation to Number in Excel

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.

Insert the LOWER Function to Convert Scientific Notation to Number in Excel

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

Insert the LOWER Function to Convert Scientific Notation to Number in Excel

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.

Apply the PROPER Function to Convert Scientific Notation to Number in Excel

  • Now, type the PROPER function in the Formula Bar. The PROPER function is,
=PROPER(B5)
  • Where B5 is the cell reference of scientific notation.

Apply the PROPER Function to Convert Scientific Notation to Number in Excel

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

Apply the PROPER Function to Convert Scientific Notation to Number in Excel

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.

Apply the PROPER Function to Convert Scientific Notation to Number in Excel

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


Similar Readings


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.

Use the TEXT Function to Convert Scientific Notation to Number in Excel

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

Use the TEXT Function to Convert Scientific Notation to Number in Excel

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.

Apply the CONCATENATE Function to Convert Scientific Notation to Number in Excel

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

Apply the CONCATENATE Function to Convert Scientific Notation to Number in Excel

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.

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

  • After that, from your Home ribbon, go to,

Home → Number → Arrow Button

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

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.

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

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.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo