convert scientific notation to double

Question

Does anyone have a function that converts a string in scientific notation to a double data type?  Thanks.

Answer 1

Hi

Can you try if CDbl works for you

Sub String2Double()

Dim sSciNotn As String
Dim dSciNotn As Double

sSciNotn = "2.3E2"

dSciNotn = CDbl(sSciNotn)


End Sub


Cheers
Shasur

Answer 2

HI Shasur,

 

That works just fine.  Would never have thought it would be so simple.

 

Thanks very much.

 

Regards

 

Don