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.


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.

Steps:

  • Activate Cell C5.
  • Type the following formula in it-
=3^B5
  • Then just press the Enter button to get the output.

Manually Set Scientific Notation to Powers of 3 in Excel

  • Finally, drag down the Fill Handle icon to copy the formula for the other powers.

Manually Set Scientific Notation to Powers of 3 in Excel

Soon after, you will get all the outputs like the image below.

Manually Set Scientific Notation to Powers of 3 in Excel


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.

Apply POWER Function to Set Scientific Notation to Powers of 3 in Excel

  • After that, drag down the Fill Handle icon to copy the formula for the other cells.

Apply POWER Function to Set Scientific Notation to Powers of 3 in Excel

Then you will get all the results.

Read More: How to Enter Scientific Notation in Excel (4 Methods)


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

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.

How to Convert a Scientific Notation to Text or Number in Excel

  • Later, click on the drop-down icon beside General.

How to Convert a Scientific Notation to Text or Number in Excel

  • From the drop-down list select the Number option.

How to Convert a Scientific Notation to Text or Number in Excel

Now see that all the outputs are converted to numbers.

How to Convert a Scientific Notation to Text or Number in Excel


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.

How to Convert a Scientific Notation to Text or Number in Excel

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

Read More: 3 Methods to Convert Scientific Notation to Text in Excel


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.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo