Formatting numbers

[Mark McDonough]

How do I format numbers such that they appear like below:

On selecting the "," icon, format the numbers in this way 100 to become
100.00 and if it is negative then (100.00).
Likewise on selecting the "$" icon then display the number in this way 100
to become $100.00 and if it is negative then $(100.00).

The location of the dollar sign should line up down the column irrespective
of the length of the amount. I don't know why Excel doesn't do this by
default.

How do I then get Excel to always do this formatting by default.

Cheers
Mark

 

[Bernard Liengme]

Experiment with Format |Cells and see how Currency differs from Accounting
Then make a Custom Format that does what you want.
best wsihes