Hi everone,

I have this line of VBA code:

ARngSolution(Cline, Aline).Value = Val(Left(ARngSolution(Cline,
Aline).Value, 7))

One of the values that it writes down comes like this: 3.84894 while
when I checked it using MsgBox, it came as this: 3.84894E-02

What should I do to let the code write it correctly as: .0384894?

Regards,
Mike