Displaying negative values in parentheses

[Andy]

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]

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

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

 

[Andy]

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



Gord Dibben MS Excel MVP

 

[Andy]

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



Gord Dibben MS Excel MVP

Thanks muchly.