G
Guest
I need a custom format that puts a number in parentheses whether it is
positive or not. I cannot treat the cell as a text cell and just enter the
parentheses manually, because I need to use the number from this cell in a
computation. It appears that all of the custom formats provided (listed under
the "Number" tab of the "Format Cells" dialog box) only apply parentheses if
the number is negative. Any ideas?
positive or not. I cannot treat the cell as a text cell and just enter the
parentheses manually, because I need to use the number from this cell in a
computation. It appears that all of the custom formats provided (listed under
the "Number" tab of the "Format Cells" dialog box) only apply parentheses if
the number is negative. Any ideas?