How do you change the excel number default settings?

[Garry Siskos]

There is no brackets on my negative numbers in excel. I have gone through
the cell format, custom, accounting, or currency, choices, but none exists.
Can someone advise as to where to set this as a default setting?

 

[Jim Rech]

Go into your Windows Regional Settings and then Customize. On the Currency
tab (not Number) select a Negative Currency format that has parens. Then
restart Excel.

--
Jim
| There is no brackets on my negative numbers in excel. I have gone through
| the cell format, custom, accounting, or currency, choices, but none
exists.
| Can someone advise as to where to set this as a default setting?

 

[Gord Dibben]

Garry

If negative brackets are not available in the Number>Negative Numbers dialog.

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)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OK>Apply your way out.


Gord Dibben Excel MVP


On Thu, 15 Dec 2005 13:51:02 -0800, Garry Siskos <Garry