Scientific Notation to Decimal Value

[Dimster]

Hi bplus .. thanks for the routine, it will likely solve my problem of a zero result. 

I see where there is a ReDim of 1 as long. How does dimensioning "1 as long"  fit into the overall scheme of determining if a result is expressed in Scientific Notation? Isn't a value of 1 by it's nature a Single? I don't think I have seen that before and wonder if it may have other applications.