We have a process where we mail merge numbers from a data source into a Word doc. We would like to have negative numbers in parentheses and have the far right digit before the parentheses line up with the last digit of a positive number above it. Right now, the far right bracket will only align with the far right digit above it, so it makes the alignment of the numbers on the right look uneven.

Current:
1,234,567
(890,123)

Desired format:
1,234,567
' (890,123)
Ignore apostrophe but I needed to add this in so I could get it to present properly for the purposes of this post.



Anyone know how to fix this?