excel forms

J

Jim Lavery

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

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
 
Top