Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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

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

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

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

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