Unlike Microsoft Excel, Google Sheets don’t allow you to directly insert symbols from within the document.

In addition to this, you can combine the CHAR formula with a cell reference.įor example, if you have typed 15 in cell A1 and you want to convert it into 15°, you can simply use this formula: =A1&CHAR(176) The best thing about this trick is that you can use the CHAR formula with other formulas or text strings to add the degree symbol to it.įor example, if you want to type 15° in a cell, you can simply use the formula below: =15&CHAR(176) The formula will automatically convert to a degree symbol. Type =CHAR(176) and then press the enter key.Simply double click on the cell where you want to insert the symbol.So you can use the below formula to get the degree symbol in a cell in Google Sheets: =CHAR(176)īelow are the steps to use this formula to get the degree symbol in Google Sheets: Google Sheets has a CHAR function that can be used to quickly get a symbol by giving its ASCII code.Īnd in case of a degree symbol, that code is 176. Double click on the specific cell where you want to insert it.īelow is the degree symbol that you can copy and paste in a Google Sheets cell: ° Insert Degree Symbol Using the CHAR Formula.Copy the degree symbol already available in your Google sheet or simply copy it from a web page on the internet.Perhaps the easiest way to insert a degree symbol in a Google spreadsheet is by copying and pasting it. You can simply copy the symbol and paste it in a specific cell(s). Pro Tip: Once you have used this keyboard shortcut to insert a degree symbol in the Google spreadsheet, you don’t have to repeat the steps every time you need to add the symbol. If you don’t have a numeric keypad, press the Num Lock key on the keyboard to enable it and then use this keyboard shortcut. Important: Please note that the keyboard shortcut will only work if you have 10 keys in the numeric keypad on your keyboard.

How to get degree symbol in word on mac