excel vba, rounding a textbox value 1

[Zebadiah]

My problem is that the calculated value is too small, so in the text box it displays as
5.209933-E02
When what I want is
0.0521

I've tried Round as a function, but vba doesn't support it, and my IT just reinstalled everything on my machine, EXCEPT the VBA help files.

thanks in advance

 

[segmentationfault]

TextBox1.Text = Format(TextBox1.Text, "0.#####&quot

 

[Zebadiah]

Already tried that.

It seems to ignore it in favor of scientific notation.

 

[DuckBill]

If it's a cell that you are trying to change, how about:

Selection.NumberFormat = "0.0000"

 

[Zebadiah]

Nope, the cell value displays correctly.
But in the textbox on my form, its in scientific notation

 

[Store300]

Where is the number feeding from? If its feeding from somewhere already formatted as scientific notation it may be picking that up, in which case re-format your source data. Store300

Store300@ftnetwork.com

 

[Zebadiah]

Feeding from a calculation that isn't in scientific format.

Wound up getting it to finally display right by making the text box twice as large as I'd like.