number format change

[mikerobe]

Hi
While running a macro my number formats changes to scientific notation
as follows
08E000123 changes to 8.00E+123 and 08E000012 changes to 8.00E+12 while
08E001234 stays as 08E001234. Its like if there is more than 2 zeros
after the E the number changes to scientific notation. How can I stop
this in the Macro.

Thanks
Eddie

 

[Gary''s Student]

Sub mikerobe()
Dim x As String
x = "08E000123"
End Sub