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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
If negative parentheses 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

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.
Click to expand...

Gord Dibben MS Excel MVP
 
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
 
Back
Top