SSRS Report Number Formating for Negative Values

Show negative numbers as (2,123) not -2,123.  


The SSRS number formats use '-' instead of ().  


Put 
Format code = ##,###,###.00;(##,###,###.00)
for that column.