I want to set up a number format to convert zeros to a hypen and also retain the number format to format negative numbers with red font and surrounded by parentheses.

So far I have this as the number format 
$#,###,###,##0;;-
I'm now trying to add the next part of formula to add the formating for red font for negative numbers which is 
$#,###,###,##0;;-);[Red]($#,###,###,##0;;-)
Excel doesn't like the second formula and I can't figure what is wrong with it. I think I am close... Thanks for any comments.