I have customised a number format in excel to bracket negative numbers.
However the numbers will not line up with the positive numbers in the same
column.

How do I change this? It is essential that they line up as I am producing
accounts for third parties.