Negative Formatting ( ) Alignment

How to show negative values displayed in brackets so that it is aligned properly with positive values in the same column. That is, the right bracket of the negative value is as follows:

(1,234.56)
800.12 - so that 2 is aligned underneath 6

I have done research on the forum and help on vba and got the following

"#,##0.00_);[Red]($#,##0.00)"

I understand that the underscore is needed for the alignment.
However, when I include the _) the above is shown as follows:

(1,234.56)
800.12_) the underscore and bracket are included and the bracket and is aligned underneath the right bracket above.