I am sorry for asking this but I am confused. For example Shall I write this as Format(Text 15/ Text 141, "Fixed")
Sorry for inconvinience but I have just started learning VB.
You could certainly try it that way, and see what happens.
Where I included "variable", this could be any expression which evaluates to a number. If you use
Text15 / Text141 (I'll assume these are two textbox controls) then VB would use the default property of these controls. In the case of the textbox, the default property is
.Text, which is a string. In such a case, I personally would use the
Val( ) function to convert each of them to numeric format, but in fact VB is quite forgiving in this area and will probably do that conversion for you.
I believe that trial and error is a very important part of learning programming. Try everything you can think of. If it doesn't work, at least you know for next time. And once you understand
why it didn't work, you'll know something knew. :)