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!
Printable View
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!
Use Format(Text1.Text, "###,###.##;(###,###.##)"). You can add $ before it and 0 like so $#,##0.00 try reading about the function Format to learn more.