If, instead of the usual addition of a degree icon at the top of the number in Excel, you need to build a number into it, take advantage of the other articles, where it is described how to produce such calculations using formulas.
Read more: Establishing a number in Microsoft Excel
Method 1: Changing the register of the number
The fastest option of adding a degree is changed the register so that it is displayed at the top, which meets the conditions set. And although this is a fast operation, edit every cell, where there is a number that need to be denoted as a degree.
- First, press the left button on the cell to be selected, and then deploy the drop-down menu in the "number" block, which is responsible for the cell format.
- In it, select the "Text" option. If the cell is displayed as a number, it will not be possible to implement further editing, so this step is mandatory.
- Now heal the LKM and highlight with the figure that you want to designate the degree. If it is still missing, simply write it without a space after the main number.
- Click on it right-click and in the context menu that appears, select "Cell format".
- It remains only to mark the PEMICK parameter in the "modification".
- Apply new settings and return to the table, making sure the degree of display is correct.
Method 2: Using special characters
There are situations in which the previous option cannot be applied, so we suggest familiarizing yourself with the alternative to using the insertion of a special symbol. It will only be necessary to find a suitable number that is already displayed in the upper case, and then simply add it to the cell.
Note that in this table as the top register you will find numbers only from 4 to 9, so this option is not suitable if you want to specify a square or cube.
- Click the Insert tab where you click on "Symbols" and open the menu with all available signs.
- For ease of orienting in this table in the "Set" drop-down menu, specify "upper and lower indexes".
- Find there the number you want to use as a degree, and double-click on it or click on the "Paste" button.
- Close the table with characters and see how the degree is displayed in the cell after the main number.
Method 3: Adding an equation
The ability to add an Excel equation allows you to create a wide variety of mathematical formulas of any complexity and insert them into the table. The functionality of the tool responsible for the equation includes a blank with a number and its degree, the addition of which is true:
- Go to the "Insert" tab and expand the "Symbols" block.
- This time select "Equation".
- The table will appear for the equation that can be moved to any area, and then open the "Structures" drop-down menu.
- Among those present structures, their miniatures can already understand that now it is necessary to choose the "index".
- A list with upper and lower indexes will appear - to write a degree you need to choose the first option.
- In turn, click on each added square and write numbers in them.
- Part of the mathematical formula is ready, but if you need to add other parts of it, use the newly described editor, choosing suitable structures.