◦ Degree Symbol in Excel ◦

To add a Degree Symbol in Excel follow below steps:
Hold down the ALT key and on the numeric keypad tap 0176
or
VBA
Sub Degree_Symbol() For Each ocell In Selection If Application.IsNumber(ocell) Then ocell.NumberFormat = "0" & Chr(176) & """""" Else: ocell.NumberFormat = "General" End If Next ocell End Sub