Lining up decimal points with negatives in brackets

F

frances

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
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Displaying negatives with (brackets) 3
Excel does not accept text format! 0
Negative Numbers in Brackets 2
formatting negative numbers 1
How do I align numbers in different cells when some are in bracke. 2
Moving decimal place to show currency in £000's 1
Decimal Points in cells 3

Top