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

My Excel does what you require. FormatCellsNumber tab, Custom, in the Type box, enter:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

I think it depends on your Windows International settings.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"frances" wrote in message ...
| 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

Thanks!!! That works perfectly!



"Niek Otten" wrote:

My Excel does what you require. FormatCellsNumber tab, Custom, in the Type box, enter:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

I think it depends on your Windows International settings.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"frances" wrote in message ...
| 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