excel vba convert cell value to number code example
Example: vba text to general
'VBA ONLY
Sub CleanTextToGeneral()
With Selection
.NumberFormat = "General"
.Value = .Value
End With
End Sub
'VBA ONLY
Sub CleanTextToGeneral()
With Selection
.NumberFormat = "General"
.Value = .Value
End With
End Sub