excel forms

[Jim Lavery]

Can anyone tell me how you can get a text box to display a number in the
format 0.00 ?

 

[Dave Peterson]

Dim myVal as double
myval = 3
textbox1.value = format(myval,"0.00")

 

[dominicb]

Good evning Jim Lavery

This code will show the value of 100 to two decimal places i
textbox1:

TextBox1.Value = Format(100, "#,###.00")

HTH

Dominic