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 ?

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

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

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.