Display numbers in a userform txtfield as numbers with a comma
 

Hello experts,
I am using a form for the user to input wage information and I would like
the numbers to display with the thousands separater and have decimal points.
is there a way to do this?

Display numbers in a userform txtfield as numbers with a comma
 

When you display the numbers, format them, like so

Format(Textbox1.Text,"#,##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TimT" wrote in message
...
Hello experts,
I am using a form for the user to input wage information and I would like
the numbers to display with the thousands separater and have decimal
points.
is there a way to do this?

Display numbers in a userform txtfield as numbers with a comma
 

I guess I would use that format on an OnExit of the field?

"Bob Phillips" wrote:

When you display the numbers, format them, like so

Format(Textbox1.Text,"#,##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TimT" wrote in message
...
Hello experts,
I am using a form for the user to input wage information and I would like
the numbers to display with the thousands separater and have decimal
points.
is there a way to do this?