Just to add to Jim's words, you can can find checking things out in the
immediate window is often helpful:

x = 1 /11
? x
9.09090909090909E-02
ActiveCell.Value = x
? activecell.Value
9.09090909090909E-02
? activecell.Text
0.090909

activecell.Offset(1,0).Select
ActiveCell.Formula = "=1/11"
? activecell.Value
9.09090909090909E-02
? activeCell.Text
0.090909


--
Regards,
Tom Ogilvy


" 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