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 is![]()
Please 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