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

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