Code Still Does Not Work
Hey Bob,
Here's the deal, if I use formatting to convert a number to percent,
it make the number 100 time larger. The formatting that I am using is
this:
T4.Text = Format(T4.Text, "#0.00 %")
If T4 is .08 it shoes as 8.00 % and acts as 8.00 in formulas. I have
this formula:
T9.Text = Val(T4.Text) * Val(T8.Text)
I tried:
T9.Text = Val(T4.Text) * Val(T8.Text) * .01
But that does not seem to change the total.
Any ideas, thoughts or suggestions?
TIA
-Minitman
On Tue, 14 Dec 2004 10:33:31 -0000, "Bob Phillips"
wrote:
Now that's a challenge. Bring it on <vbg
|