Show parentheses in Accounting Format

[tiggy2]

I have Excel 2002 (XP) and want to display negative numbers in parentheses in
ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a
standard feature (I have done it before on a previous machine) and I think
there was a KB patch for this flaw. Anyone know of where I might find the
fix?

 

[Bucky]

I have Excel 2002 (XP) and want to display negative numbers in parentheses in
ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a
standard feature (I have done it before on a previous machine) and I think
there was a KB patch for this flaw. Anyone know of where I might find the
fix?

It doesn't do it when you choose Format > Cells > Number > Accounting?
(I only have Excel 2003, don't know if it's different).

 

[Gord Dibben]

FormatStyle>Accounting>Modify>Custom

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)


Gord Dibben MS Excel MVP

 

[tiggy2]

No the standard formatting for accounting style will not show the parentheses
- I'm sure it is a bug in Excel 2002

 

[Peo Sjoblom]

If it is then you should download and install a service pack

http://support.microsoft.com/kb/832671/en-us



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com