Hi Ozgur,

Try:

With TextBox1
. Text = Format(.Text, "##,##0.00")
End With


---
Regards,
Norman



"Ozgur Pars" wrote in message
...
Hello,
I am trying to find a way to format the numbers in a textbox which derives
the data from a excel sheet. Nothing too fancy but I can't figure it
out...any help?

Thanks,
Ozgur