The two numbers are exactly the same. The only difference is the format of
the number. When you place the value in a worksheet or anywhere else you will
just need to format it to the way you want. That being said you really should
not be using variants (wherever possible). You probabaly want a Double in
this case.
--
HTH...

Jim Thomlinson


" wrote:

Hi, if, using a calculator i calculate 1 / 11 = 0.0909...... If in vba
I asign X as a variant, then x = 1 /11 then i get 9.090909......E-02.
Im fairly certain these answers are both the same, but as I enter x
into a cell Id like to display it as 0.0909.... Im thinking that Im not
declaring the variable correctly. Any Ideas.
Regards Robert