Formating string as "#,###.00"
- From: "JMay" <jmay@xxxxxxx>
- Date: Fri, 9 Feb 2007 09:57:25 +0000
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..
.
- Follow-Ups:
- Re: Formating string as "#,###.00"
- From: Bob Phillips
- Re: Formating string as "#,###.00"
- Prev by Date: Re: Add-In problem with Excel2003
- Next by Date: Re: Formating string as "#,###.00"
- Previous by thread: Add-In problem with Excel2003
- Next by thread: Re: Formating string as "#,###.00"
- Index(es):
Loading
