How can I display negative numbers with parenthases in Excel?
 

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

How can I display negative numbers with parenthases in Excel?
 

Format Cells... Nymber Custom $#,##0.00_);($#,##0.00)
--
Gary''s Student - gsnu200766


"Nicole" wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

How can I display negative numbers with parenthases in Excel?
 

Select the cell with the number you want to format then: Format Cells -
Number (or Currency) - Negative numbers: Select one of the numbers in
parentheses. Works fine in Excel 2007

Tyro

"Nicole" wrote in message
...
Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

How can I display negative numbers with parenthases in Excel?
 

You could change the format of the cell, but if you want the ()'s to show up for
negative numbers in the format|cells|number tab, you'll have to change a windows
setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

Nicole wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

--

Dave Peterson

How can I display negative numbers with parenthases in Excel?
 

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 Sun, 27 Jan 2008 09:02:05 -0800, Nicole
wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

How can I display negative numbers with parenthases in Excel?
 

Thank-you so much!!



"Gord Dibben" wrote:

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 Sun, 27 Jan 2008 09:02:05 -0800, Nicole
wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!

How can I display negative numbers with parenthases in Excel?
 

On Monday, January 28, 2008 5:14:00 AM UTC+11, Nicole wrote:
Thank-you so much!!



"Gord Dibben" wrote:

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 Sun, 27 Jan 2008 09:02:05 -0800, Nicole
wrote:

Everytime I go to Format -- Cells -- Number or Currency, I can never get
the ( ) option to show up for negative numbers! HELP!!!!!!



Perfect !!! Thanks