Degree symbol is known to everybody as it is used commonly.
Every day differs from the other in respect to the weather and the most important parameter to explain the weather is the temperature.
A DEGREE IS A SMALL SUPERSCRIPTED ‘O’ WHICH IS USED IN SCIENTIFIC TERMS SUCH AS TEMPERATURE OR ANGLE MAINLY.
We always tell the temperature as DEGREE FAHRENHEIT OR DEGREE CELSIUS.
While making the reports comprising of the temperatures, we might need to enter the degree formatting in our reports.
Sometimes it becomes a problem to insert a degree symbol in Excel as this option is not available on the keyboard itself.
In this article we will learn different ways to insert a DEGREE in Excel.
There can be different ways of creating a DEGREE symbol in your sheet in Excel.
If you need the DEGREE SYMBOL for now only, you can just copy this symbol from here and use it in your sheet.
YOU CAN COPY EITHER OF THESE DEGREE SYMBOLS AND PASTE IT IN YOUR EXCEL SHEET
Google is a great tool for a lot of our requirements. We can use it to find out our symbols too. It ‘ll save us a lot of time.
This is the easiest method of inserting a DEGREE SYMBOL IN EXCEL.
It is easy because it is fast, and we don’t need to remember anything for this.
THE ONLY REQUIREMENT FOR THIS METHOD IS THE AVAILABILITY OF INTERNET.
Here are the steps.
The other method of inserting a DEGREE SYMBOL is using the SYMBOL INSERTION FACILITY from the SYMBOL TABLE.
There is a complete table in the MICROSOFT EXCEL having a full fledged list of a big number of symbols from where we can choose the symbols we like. Follow the following steps to insert the symbol in the Excel using symbol dialog box. But we have a problem with the DEGREE symbol.
The symbol will be inserted in the selected cell.
We already learnt to insert a DEGREE SYMBOL using the google , image and symbol dialog box.
We can also insert the DEGREE SYMBOL using the functions present in the EXCEL.
As we know that all the characters are given the ASCII codes and the characters which are not in the ASCII table are given UNICODE.
Luckily DEGREE is present in both.
So, we can make use of CHAR FUNCTION as well as UNICHAR FUNCTION to insert DEGREE SYMBOL in EXCEL.
THE ASCII CODE OF DEGREE IS 176 AND UNICODE OF DEGREE IS 00B0 WHICH IS EQUIVALENT TO 0176 IN DECIMAL. [ WE NEED DECIMAL VALUE IN UNICHAR FUNCTION ]
* HEX2DEC will convert HEXADECIMAL format TO DECIMAL FORMAT.
The following picture shows the result.
For using the function and attaching the degree symbol with a number, we can make use of the CONCATENATION OPERATOR or CONCATENATE FUNCTION or CONCAT FUNCTION.
Suppose we have 41 in cell A1.
If we want to show 41 degree in A2, we can use the formula as
We already learnt various ways to insert the DEGREE SYMBOL in Excel.
Now suppose we have a number of cells to which we want to apply the degree symbol at once.
We can use the following ways.
The following animated picture shows the complete process.
We have temperature readings where we need to apply the degree symbol with all the readings.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE