How do I change the display of negative values to parentheses?
 

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

How do I change the display of negative values to parentheses?
 

The comma (,) symbol should be on your Formatting Toolbar at the top of the
screen. That will make -10 look like (10.00).
If it isn't there, you can put it back by...
1) Select 'Tools' from the top menu
2) 'Customize...'
3) 'Commands'
4) In the 'Categories' box, select 'Format'
5) In the 'Commands"' box, scroll down until you see ', Comma Style'
6) When you left-click on ', Comma Style' a plus sign will appear.
7) Continue to hold down the mouse button and drag the ', Comma Style' up to
your toolbar
8) Let go of the mouse button
9) Select 'Close'

The ', Comma Style' should now be available.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"accounts.payable" wrote:

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

How do I change the display of negative values to parentheses?
 

If negative parentheses are not available in the NumberNegative Numbers dialog.

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

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative 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 OKApply your way out.



Gord Dibben Excel MVP

On Fri, 27 Oct 2006 10:16:02 -0700, accounts.payable
wrote:

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

Gord Dibben MS Excel MVP

How do I change the display of negative values to parentheses?
 

--
Dickson


"accounts.payable" wrote:

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

How do I change the display of negative values to parentheses?
 

--
Dickson


"accounts.payable" wrote:

I have just started using Micrososft Office 2003 for Excel and noticed that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used to
this idea in the older version.

How do I change the display of negative values to parentheses?
 

Use a Custom Format of #,##0 ;(#,##0);- ;
See also
The negative number inside parenthesis format is not available in Excel for
numbers or for currency http://support.microsoft.com/kb/832285
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Dickson Nshindano" wrote in message
...

--
Dickson


"accounts.payable" wrote:

I have just started using Micrososft Office 2003 for Excel and noticed
that
the options for showing negative values is only a negative sign. I was
wondering if there is a way to change this to parentheses as I was used
to
this idea in the older version.

How do I change the display of negative values to parentheses?
 

If negative brackets are not available in the NumberNegative Numbers dialog.

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

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative 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 OKApply your way out.


Gord Dibben Excel MVP

On Mon, 10 Dec 2007 03:25:00 -0800, Dickson Nshindano
wrote: