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