| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating string as "#,###.00"
Presently in my code I have:
UserForm1.TextBox1.Text = str6 UserForm1.Show vbModeless Where str6 = "22(vbcr)33.18(vbcr)-125(vbcr)1191.56" Which shows up (in Userform) as: 22 33.18 -125 1191.56 What can I further do to format somewhere(?) to get (in the userform) as: 22.00 33.18 (125.00) 1,191.56 ?? Thanks in advance.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Converting string "061123" into a date "23/11/06" | Excel Programming | |||
| Making "examp le" become "examp_le" in a string | Excel Programming | |||
Threaded Mode
