| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying negative values in parentheses
Excel 2003 seems to ignore regional settings when I set them to display
negative values in parentheses eg. ( 2.3 ) = -2.3 Is there a solution to this short of creating a custom format for every new workbook ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying negative values in parentheses
Andy
When changing Regional Settings make sure you select the parens under the "Currency" tab, not under the "Number" tab. Gord Dibben MS Excel MVP On 28 Aug 2006 06:03:22 -0700, "Andy" wrote: Excel 2003 seems to ignore regional settings when I set them to display negative values in parentheses eg. ( 2.3 ) = -2.3 Is there a solution to this short of creating a custom format for every new workbook ? Gord Dibben MS Excel MVP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying negative values in parentheses
Gord Dibben wrote: Andy When changing Regional Settings make sure you select the parens under the "Currency" tab, not under the "Number" tab. Gord Dibben MS Excel MVP On 28 Aug 2006 06:03:22 -0700, "Andy" wrote: Excel 2003 seems to ignore regional settings when I set them to display negative values in parentheses eg. ( 2.3 ) = -2.3 Is there a solution to this short of creating a custom format for every new workbook ? Gord Dibben MS Excel MVP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying negative values in parentheses
Gord Dibben wrote: Andy When changing Regional Settings make sure you select the parens under the "Currency" tab, not under the "Number" tab. Gord Dibben MS Excel MVP On 28 Aug 2006 06:03:22 -0700, "Andy" wrote: Excel 2003 seems to ignore regional settings when I set them to display negative values in parentheses eg. ( 2.3 ) = -2.3 Is there a solution to this short of creating a custom format for every new workbook ? Gord Dibben MS Excel MVP Thanks muchly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative Numbers in Parentheses | Excel Discussion (Misc queries) | |||
| calculation with hours and minutes - input of negative values | Excel Discussion (Misc queries) | |||
| displaying negative values | New Users to Excel | |||
| Axis labels on negative values | Charts and Charting in Excel | |||
| Negative Values Only | Excel Discussion (Misc queries) | |||
Linear Mode
