Display numbers in a userform txtfield as numbers with a comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

decimals: in Europe they use a comma 2
Fractions in a userform. 2
Convert a number to text and add a comma separator for thousands 2
Date showing as numbers in Textbox on Userform 2
Excel data display userform problem 3
How to retrieve number of visible digits after decimal point in VBA 5
VBA NumberFormat problem 5
adding actual numbers in columns 3

Back
Top