Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change all negative values in a column to = 0? | Excel Worksheet Functions | |||
How do I change a range of values from + to -? | Excel Discussion (Misc queries) | |||
How to display the negative bar in bar chart? | Charts and Charting in Excel | |||
Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions |