Displaying negative values in parentheses

  • Thread starter Thread starter Andy
  • Start date Start date
A

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 ?
 
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 ?
Click to expand...

Gord Dibben MS Excel MVP
 
Gord said:
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
Click to expand...
 
Gord said:
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
Click to expand...


Thanks muchly.
 
Back
Top