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
|