Add Insert Degree Symbol in Excel
Let’s say you have a list
of numbers in a column and you want to add degree symbol with
all of them.
Sub degreeSymbol()
Dim rng As Range
For Each rng In Selection
rng.Select
If ActiveCell <> "" Then
If IsNumeric(ActiveCell.Value) Then
ActiveCell.Value = ActiveCell.Value & "°"
End If
End If
Next
End Sub
No comments:
Post a Comment