T
tjtjjtjt
For numbers that contain a dollar sign and are enclosed in parentheses when negative. The opening parenthesis would align one character inside of the $, if both are present:
_($* #,##0_);_($(* #,##0);_(* "-"_);_(@_)
For numbers in cells that don't have $ signs:
_(__* #,##0_);_(__(* #,##0);_(* "-"_);_(@_)
This second format is for numbers located further down a column that starts with a number that has a $ sign. This aligns the opening ( with the opening ( in the negative part of the first format.
What I need is a way to keep the closing parenthesis next to the number but have it underlined--preferably without adding any other characters--when I apply single or double accounting style underlining. I suspect accounting style underlining is designed to stop with the last number, but since it includes the opening (, I've been asked to make it include the closing ) as well.
Is this at all possible?
Underlining the whole cell is not an option.
tj
_($* #,##0_);_($(* #,##0);_(* "-"_);_(@_)
For numbers in cells that don't have $ signs:
_(__* #,##0_);_(__(* #,##0);_(* "-"_);_(@_)
This second format is for numbers located further down a column that starts with a number that has a $ sign. This aligns the opening ( with the opening ( in the negative part of the first format.
What I need is a way to keep the closing parenthesis next to the number but have it underlined--preferably without adding any other characters--when I apply single or double accounting style underlining. I suspect accounting style underlining is designed to stop with the last number, but since it includes the opening (, I've been asked to make it include the closing ) as well.
Is this at all possible?
Underlining the whole cell is not an option.
tj