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 formatI'm now trying to add the next part of formula to add the formating for red font for negative numbers which isPlease Login or Register to view this content.
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.Please Login or Register to view this content.
Bookmarks