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..
|