Bob , Norman,
thanks alot for your help.

Ozgur

"Bob Phillips" wrote:

Textbox1.Text = Format(Range("A1").Value,"$#,##0.00")

for example.

If the range is already formatted you could use

Textbox1.Text = Range("A1").Text

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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