Excel: How to convert "string" to a "number"?

I think the value function can be useful for you

 = VALUE(< CELL >)

PD:

In spanish we use the function VALOR:

 = VALOR(< CELL >)

i think it should be the same on english

I use this little macro

Sub txttonum()
    For Each tcell In Selection.Cells
        If TypeName(tcell.Value) = "String" Then
            tcell.Value = Val(tcell.Value)
        End If
    Next
End Sub

Which converts all the highlighted cells to numbers if they're strings

Excel: How to convert "string" to a "number"?

Related

Recent Posts