If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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: |
Thread Tools | |
Display Modes | |
|
|