My current project I need to align data on some reports and I'm using
the mask with parenthesis for negative numbers -- the specific mask is
#,0.00;(#,0.00) -- problem is the columns when right aligned with each
other and right aligned in each field do NOT align positive and negative
numbers properly. The mask should pad the field with space for those
positive numbers leaving room for the right parenthesis on the negative
numbers.
As is, the right parenthesis is aligned with the right most digit of the
positive numbers above or below in that column.
This behavior doesn't seem correct, or I'm missing something.