Excel has the default format to set the scientific notation for 10 to the power of a number. But there are some more ways to set the scientific notation for powers of any number. In this article, we’ll learn 2 quick ways to set scientific notation to powers of 3 in Excel with sharp steps and vivid illustrations.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
2 Ways to Set Scientific Notation to Powers of 3 in Excel
1. Manually Set Scientific Notation to Powers of 3 in Excel
First of all, we’ll learn a manual way to set Scientific Notation to powers of 3. For that, I have placed some random positive and negative numbers in the following dataset.
- Activate Cell C5.
- Type the following formula in it-
- Then just press the Enter button to get the output.
- Finally, drag down the Fill Handle icon to copy the formula for the other powers.
Soon after, you will get all the outputs like the image below.
2. Apply POWER Function to Set Scientific Notation to Powers of 3 in Excel
Let’s use a function now. We’ll use the POWER function to set Scientific Notation to powers of 3. We’ll give input the number and power individually and the POWER function will give the output directly. For that, I have placed the number- 3 in Column B and powers in Column C.
- Write the following formula in Cell D5–
- Later, just press the Enter button.
- After that, drag down the Fill Handle icon to copy the formula for the other cells.
Then you will get all the results.
How to Convert a Scientific Notation to Text or Number in Excel
After setting the numbers to Scientific Notation there might come a question in your mind that how to convert them as numbers or text. No worries, that is quite easy. I’ll convert them in Column D.
1. Convert to Number
- Copy the outputs.
- Then right-click your mouse in the first cell of Column D.
- Then select Paste as Values from the Paste Options after appearing the Context menu.
- Later, click on the drop-down icon beside General.
- From the drop-down list select the Number option.
Now see that all the outputs are converted to numbers.
2. Convert to Text
- Select the outputs and copy.
- Later, right-click your mouse in the first cell of Column D.
- Then just select Paste as Values from the Paste Options.
- After that click on the drop-down icon beside General.
- Finally, from the drop-down list select Text.
Now have a look, Excel has converted all the values to Text and text values get aligned left.
I hope the procedures described above will be good enough to set scientific notation to powers of 3 in Excel. Feel free to ask any question in the comment section and please give me feedback.