Mathematica does not understand 1.2E-03, use 1.2*10^-03 instead : Double « Data Type « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Data Type
3. Double

Mathematica does not understand 1.2E-03, use 1.2*10^-03 instead

 
Function Scientific(s As String) As String
  Dim pos%
  pos = InStr(s, "E")
  If pos Then
    Scientific = Left(s, pos - 1) + "*10^" + Mid(s, pos + 1)
  Else
    Scientific = s
  End If
End Function

 

Related examples in the same category