text boxes

[batsheva]

I would like to format the text of a text box that it should comma separators and have parenthesis when it is a negative number.
e.g. -200000 should be (200,000)

Thanks!

[Raptors Fan]

Use Format(Text1.Text, "###,###.##;(###,###.##)"). You can add $ before it and 0 like so $#,##0.00 try reading about the function Format to learn more.