"$#,##0" will get rid of the decimal places.

Could you clarify the percentage requirement. Maybe you want another text
box?
Or are you working with a combo box or list box? I don't understand the
separate field remark.

"geebee" wrote:

hi,

I have the following:

TextBox3.Value.Format = "$#,##0.00"

I am trying to format the UserForm field to have zero decimal places, and
another field to be a percent.

How?

Thanks in advance,
geebee