◦ 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