I want to display the values in a financial report (created in Excel 2010) so that the values less than 0 will display with parentheses in Red font. When I apply the following format I get inconsistent results: #,##0);[Red](#,##0) .
Strangely, in certain Excel reports, some positive values are also displaying in Red. Again, only SOME of the values are displaying incorrectly. Does anyone know what causes this? These are formal, regular financial reports that must be correct.
See attached slice of a report.
Thanks for your help.