Lining up decimal points with negatives in brackets

[Guest]

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

 

[Niek Otten]

My Excel does what you require. Format>Cells>Number 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

| 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

 

[Guest]

Thanks!!! That works perfectly!