| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Linear Mode
