How do I get brackets in format cells accounting?

A

allan

In Excel 2000, "format cells accounting" got me brackets around negative
numbers. Excel 2003 gives me a negative sign. Is there any to change this?
I know I can get the format I want in custom, but this seems to require
formatting each cell.
 
M

Mental Block

Highlight all the desired cells. Right click and select Format Cells. From
the Number tab you can select the desired view.
 
G

Gord Dibben

Allan

Just when using the Accounting format? When you Format>Cells>Number>Number do
you see an option for brackets?

If not..........

This is a function of your Regional Settings in Windows OS.

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Apply and OK>Apply your way out.

You will have to close Excel then re-open to see effects.

If you already have the brackets format available you could go to
Format>Styles and select Accounting and modify to your liking.

Gord Dibben Excel MVP
 
Top