Can anyone tell me how to line up a list of figures so that the decimal
points of all of them are lined up when negative figures are shown in
brackets. So far I have found that I can either line up the figures using
the accountancy format but can't get negative numbers in brackets or can have
the negatives in brackets by formatting the cells as numbers but then they
won't line up with the decimal.

Thanks