Re: Negative figures to appear in brackets
- From: Gord Dibben <gorddibbATshawDOTca>
- Date: Wed, 19 Apr 2006 12:14:46 -0700
mad
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 Wed, 19 Apr 2006 07:18:02 -0700, madbat <madbat@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
In excel, how can I get negative figures to appear in brackets
ie (7,500)
Gord Dibben MS Excel MVP
.
- Prev by Date: Re: cHANGIN A CELL COLOUR BASED ON A CELL VALUE
- Next by Date: Re: Sorting
- Previous by thread: Re: Negative figures to appear in brackets
- Next by thread: cHANGIN A CELL COLOUR BASED ON A CELL VALUE
- Index(es):
Relevant Pages
|
