Md. Abdur Rahim Rasel
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.
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.
