Excel 2003 SP2
 

when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install

Excel 2003 SP2
 

Do not re-install Office or 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 Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
wrote:

when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install

Gord Dibben MS Excel MVP

Excel 2003 SP2
 

Thanks Gord worked great instructions were perfect

"Gord Dibben" wrote:

Do not re-install Office or 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 Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
wrote:

when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install

Gord Dibben MS Excel MVP

Excel 2003 SP2
 

Thanks for the feedback.

Gord

On Mon, 18 Sep 2006 18:50:01 -0700, J M Sutherland
wrote:

Thanks Gord worked great instructions were perfect

"Gord Dibben" wrote:

Do not re-install Office or 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 Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
wrote:

when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00
any suggestions besides re-install

Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP