View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default 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