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.
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: Excel Engineering Number Format
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.
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.
Related Articles
- How to Display Power in Excel
- How to Set Scientific Notation to Powers of 3 in Excel
- Prevent Excel from Converting to Scientific Notation CSV
- How to Remove Scientific Notation in Excel
- Excel Scientific Notation Without e
<< Go Back to Scientific Notation in Excel | Number Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
