Number formate

[Syed Haider Ali]

Hello Freids

i want to see figures in a user form just like that 900,000.00 with two decimals instead of 900000.

i am using this code

with textbox1

.value = format (.value, "###,##0.00")

end with

this code is working with comma and decimals in textbox3, where i am getting the value with formula. but in textbox1 and textbox2 where i am putting the values directly it is not working (suppose to put 16033 in textbox1, it is shown 1 only )

please guide me.

Thanks.

[BrianB]

Your code must go into the textbox OnChange event.