Accounting Format Parentheses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tiggy2 - 24 Jul 2006 21:49 GMT

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?

Reply to this Message

David McRitchie - 30 Jul 2006 15:00 GMT

Look in Tools, cells, Number instead of Accounting.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> 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?

Reply to this Message