| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add a comma following a series of numbers | Excel Discussion (Misc queries) | |||
| Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
| how to combine numbers with the comma | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) | |||
Linear Mode
