How to Set Scientific Notation to Powers of 3 in Excel (2 Methods)

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.

How to Set Scientific Notation to Powers of 3 in Excel: 2 Easy Ways

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.

Steps:

Activate Cell C5.
Type the following formula in it-

=3^B5

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.

Steps:

Write the following formula in Cell D5–

=POWER(B5,C5)

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.

Read More: How to Display Power in Excel

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 about 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

Steps:

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

Steps:

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.

Download Practice Workbook

You can download the free Excel template from here and practice on your own.

Scientific Notation Powers of 3.xlsx

Conclusion

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.