Excel 2003 SP2

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

Guest

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
 
Do not re-install Office or Excel.

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


On Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
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
Click to expand...

Gord Dibben MS Excel MVP
 
Do not re-install Office or Excel.

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


On Mon, 18 Sep 2006 14:57:02 -0700, J M Sutherland <J M
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
Click to expand...

Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why doesn't my Excel '03 let me use brackets for negative numbers 2
Default Number Format for all WEorksheets 6
Negative numbers in parenthesis if not shown in drop down box 7
Negative Number Formatting Excel 2007 1
Excel not using regional settings 6
data validation fonts differ in drop down box 1
IF AND Nested Functions - Formula Not Working 0
Format change when user select a Factor on drop down box 3

Back
Top