November 30, 2014 at 1:24 PM #1 I am trying to change a string to a double so I can do math on it later.CDbl does not seem to work.Error Code"Type Mismatch" Code Dim Eph as String, deg As Double deg = CDbl(Left(Eph, 2))
November 30, 2014 at 1:32 PM #2 Re: String to doubleI have no issue Code Sub Macro1() ' Dim Eph As String, deg As Double Eph = "12AAA" deg = CDbl(Left(Eph, 2)) ' End Sub Send more information