I am using this custom format to reflect percentages as a number, carrying it to two decimals #,##0.00,, but I need it to show up in [Red] and in parentheses when it's a negative number. I've experimented but nothing's worked.
Suggestions?
I am using this custom format to reflect percentages as a number, carrying it to two decimals #,##0.00,, but I need it to show up in [Red] and in parentheses when it's a negative number. I've experimented but nothing's worked.
Suggestions?
Custom format cell as:
Does that help?![]()
Please Login or Register to view this content.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks